The goal is to read all files in a specified folder and merge the data from these files into one structured table in one consolidated Excel file.
Things to note:
- All excel files do not have the same Sheet Names. I am not sure how to navigate this as it seems in order to read a range, you have to specify a sheet name. However, the data is always on the first tab of the excel sheet.
- I will need to read specific row/column names for each file, which will then be transferred to the consolidated file, structured into one table. These column/rows are not necessarily on the same rows, however there are key words i.e. “Tester” that is standardized among all files. Will I be able to use a key word function to locate the data?
I have little to no experience with UIPath but can learn quickly if the steps explained to me. I can give more details as well but this is the basic idea.
Thanks in advance!