Excel consolidation

Hi guys

Grateful if anyone help on the below task

Read all Excel files in a specified folder and merge the data from these files into one Excel file.

Before merging in to single excel file, Need to do filter activity in the date column in excel.

Filter details needs to be read from configuration file.

In all the excel date column contains whole month dates. Need to pick the specific week data mentioned in the configuration file.


Please post topics in correct category and with correct tags. This case has nothing to do with Orchestrator and Orchestrator Mobile. Thanks


You can use Balareva Excel Activities from go.uipath.com

What do you mean by merge - just copying all the excel sheets to a single excel workbook. Or into a single sheet by data.

You can also write macro for the same and can do filter and move the sheets from one excel to another.