Ask a Question

explicitly get a value from an excel spreadsheet using row,column

SOLVED
jloyzagawh
Contributor

explicitly get a value from an excel spreadsheet using row,column

How can I call using the specific column,row assignation "A1"?

1 REPLY 1
NisHera
Valued Contributor

you can open xl using below code (in jScript)

  var app = Sys.OleObject("Excel.Application");
  var book = app.Workbooks.Open(fname);
  var sheet = book.Sheets(sheetName);

then get value using
  app.Cells(A,1)

 

more

cancel
Showing results for 
Search instead for 
Did you mean: