Forum Discussion
My rough guess is that the problem is not on that line but actually on the line where you're opening the file. "Excel.workbook" is undefined which means there was a problem opening the workbook.
What is the value of the excel path?
Hi tristaanogre ,
excelpath is as below
var dataFileName="PartDetails.xlsx";
var sCurPath = Sys.OleObject("Scripting.FileSystemObject").GetAbsolutePathName(".");
var excelPath = sCurPath + "\\Data\\" + dataFileName;
I am not getting any error when removed mentioned two lines of code, the value of active sheet is getting retrieved.
I am using those lines to point to specific sheet. is the two lines of code is correct or is there any others methods to make specific sheet using COM object and in javascript?
Thank you,
Anumolu.
Related Content
- 2 years ago
Recent Discussions
- 9 hours ago