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.
Thanks
Krishna
Pablito
(Pawel Wozniak)
2
Please post topics in correct category and with correct tags. This case has nothing to do with Orchestrator and Orchestrator Mobile. Thanks
sarathi125
(Parthasarathi)
3
@Krishnakumar149,
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.