Forum Discussion

jloyzagawh's avatar
jloyzagawh
Contributor
9 years ago

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

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

  • 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

    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