Question

4
Replies
38
Views
Close popover
Kasia Markowska (KasiaM40)
UNIQA

UNIQA
PL
KasiaM40 Member since 2020 13 posts
UNIQA
Posted: January 29, 2021
Last activity: February 2, 2021

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?

***Edited by Moderator: Pooja Gadige to change content format from Discussion to Question, add platform capability tag***
Pega Robotic Process Automation Robotic Process Automation Data Integration Other Industry Robotics System Architect Upgrade