Combine several excel files and create pivot

Hello,
I have given several Excel files with reports. I’ve need to combine them all and create a pivot table. Please, help

1 Like

There are pre-build activities to combine excel files such as merge and to create a pivot table there is an activity called to create a pivot table. Use those pre-built activities to build your work flow

1 Like

Hi @vkrivenko,

If the files have same headers you can use merge datatable activity to merge the data into a single DT then for Pivot you can use a LinQ query or traditional loops and select function to achieve it. If you can provide some info about pivot then we can help you with some LinQ queries.

Thanks

@vkrivenko

  1. You can use read range activity to read the datatables from the excel files
  2. If the structure of that datatables are same you can use merge activity to merge all the datatables into a single datatable.
  3. One you have datatable ready, you can refer this video to create the pivot table using linq
    LINQ | LINQ Pivot | Create Pivot Table Using LINQ | LINQ Uipath | Uipath Tutorials | Coderslobby - YouTube

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.