Plz help me for the below use case
A folder contains some 300 excel files, and I need to append data of all excels together in one and below is my task to perform via RPA
- Open folder
- Read first excel, click and open it.
- Extract all the data from that excel
4.Extract the file name
- Paste the data and file name should reflect on top in new excel file
- Read second excel from folder and repeat same steps till the last file in folder
. 7. All the data will be pasted in the same excel.