Question
3
Replies
142
Views
Tech Mahindra Ltd
Posted: September 20, 2019
Last activity: September 20, 2019
Closed
Solved
Problem with using WorksheetGetUsedRange method from microsoftExcel
Hi,
I am in the middle of exporting the data of an Excel(.xls) to a data table using microsoftExcel .
To get the used range of the sheet I used the method WorksheetGetUsedRange. surprisingly I am unable to pass data to the workbook property. Even tried to hardcode it but still its not allowing me.
Also observed for .xls files, Excel connector is not working.
The method takes the _Workbook type. Try passing "ExcelWorkbook" property instead of the Workbook.