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.