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.