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.

Hi Thomz,

Thanks for your quick response.

I want to filter the data extracted from Excel sheet, so I need Table view to do that task.

https://pdn.pega.com/community/product-support/question/filter-data-com…

Kindly go over the above document for detailed explanation.

Thanks and Best Regards,

Madhukar Ganesh Chatra

Madhukar,

As Jeff mentioned in the other post, our excel connector does not contain a filter method that can be applied to a workbook.

If you wish to accomplish this strictly with the available methods found in Studio, you will need to apply the logic that was outlined in your initial post where you iterate through the excel sheet while updating the table view with the desired data and then exporting the table view data to the grid view. 

If your use case allows for you to apply filters to the workbook, you can call an autofilter through referencing the Microsoft.Office.Tools.Excel assembly in a script component and calling the autofilter method. Below is a link that goes into the method use and an example of using such a method in C#.

https://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.n…

http://www.c-sharpcorner.com/uploadfile/cubs610/using-C-Sharp-and-the-e…

Once the filter has been applied, you export the data to the gridview in the same manner that was mentioned before.