Problem with using WorksheetGetUsedRange method from microsoftExcel
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.
Keep up to date on this post and subscribe to comments
- Problem during method invocation (doPost) after login to PRPC
- Problem during method invocation
- SEVERE [http-nio-8080-exec-4] com.pega.pegarules.internal.bootstrap.PRBootstrap. Problem during method invocation doPost java.lang.ClassCastException: java.util.HashMap cannot be cast to java.lang.String at com.pega.pegarules.web.impl.WebStandadImpl.java
- com.pega.pegarules.internal.bootstrap.PRBootstrap. Problem during method invocation (doPost)
- MicrosoftExcel Connector