Excel data read not happening
Hi, I need the help to read the data from excel sheet using javascript. I am able to read the data from the 1st sheet. But not able to read from any other sheet. Please share me the code...
Forum Discussion
Hi ganapati, your code is failing because Sheets is a property of the Excel object, not the Excel.Workbooks object.
The following code will:
1. Open an Excel Workbook.
2. Select the "PersonalInformationData" Sheet.
3. Select the Cell "A1" and Log the value contained in that Cell.
var Filepath = "E:\\temp\\test.xlsx";
var Excel = Sys.OleObject("Excel.Application");
Excel.Workbooks.Open(Filepath);
Excel.Sheets( "PersonalInformationData" ).Select();
Excel.Range( "A1" ).Select();
Log.Message( Excel.ActiveCell.Value2 );
}
Hope this helps.
Regards,
Phil Baird
The following code will:
1. Open an Excel Workbook.
2. Select the "PersonalInformationData" Sheet.
3. Select the Cell "A1" and Log the value contained in that Cell.
function testExcel() {var Filepath = "E:\\temp\\test.xlsx";
var Excel = Sys.OleObject("Excel.Application");
Excel.Workbooks.Open(Filepath);
Excel.Sheets( "PersonalInformationData" ).Select();
Excel.Range( "A1" ).Select();
Log.Message( Excel.ActiveCell.Value2 );
}
Hope this helps.
Regards,
Phil Baird