How to load xls contents to DataTable? There is an issue with the microsoftExcel.ExportData block
Hi,
I am not able to use the ExportData block because the "worksheet" parameter is non-editable, I am also not able to connect a string variable to it. Other parameters in this block are fine. Restarting Pega Studio didn't help.
What is the issue here exactly? And how can I extract the data from excel to a datatable then?
Pegasystems Inc.
IN
Hi, What is your PRPC version and from which browser are trying to edit the worksheet?
You Can use MSOParseExcelFile, it accepts Binary file template as input. So, create a Binary file with all columns headings and map the column values with property accordingly.
The below link gives you the steps to follow
Pegasystems Inc.
IN
MSOParseExcelFile is deprecated from pega 8.1V. alternative is to use pxParseExcelFile
This link should be helpful https://myknowpega.com/2020/03/01/excel-processing-in-pega/ to understand on how to configure pxParseExcelFile activity to load data from excel file
Pegasystems Inc.
US
@KasiaM40 Here is simple example solution using the Excel Connector. Are you using this connector or the Microsoft Excel Connector? The latter requires a script in C# to get the used range so you can capture all the data, but it can work in either.