Forum Discussion

jloyzagawh's avatar
jloyzagawh
Contributor
10 years ago

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

How can I call using the specific column,row assignation "A1"?
  • NisHera's avatar
    NisHera
    10 years ago

    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

NisHera's avatar
NisHera
Valued Contributor
10 years ago

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