Posted: 29 Jan 2021 8:21 EST Last activity: 2 Feb 2021 9:26 EST
How to load xls contents to DataTable? There is an issue with the microsoftExcel.ExportData block
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?
***Edited by Moderator: Pooja Gadige to change content format from Discussion to Question, add platform capability tag***
@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.