Question
Exporting the Excel sheet data into Table view component
Hi,
I need to export the excel sheet data with multiple columns into Table view component. I am using the Pega-Robotic studio 8.0 the only properties that are related to data-Tableview are ApplyDefaultSort, Filter, RowFilter and sort and method that is relevent to this is Addnew.
Kindly help me to get bunch of records with multiple columns into TableView from ExcelSheet at a time without looping.
Thanks and Best Regards,
Madhukar Ganesh Chatra
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Madhukar,
You can achieve the same with the use of the ExportData method on the excel connector. The method allows you to specify the start and ending cell range that should be extracted. The returned value is a .NET datatable. So you wouldnt need to push this into a tableview. You can directly push the datatable result into the datagrid component using the datasource property. Below is a screenshot of such steps.