explicitly get a value from an excel spreadsheet using row,column
SOLVED- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-21-2015
03:44 PM
10-21-2015
03:44 PM
explicitly get a value from an excel spreadsheet using row,column
How can I call using the specific column,row assignation "A1"?
Solved! Go to Solution.
1 REPLY 1
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-21-2015
07:59 PM
10-21-2015
07:59 PM
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)
