I’M Working on a project that has several steps, below are the steps I’m having trouble completing.
- I have downloaded several excel files that i need to extract the data from and combine them into one report.
Problem: The files that i download are zipped folders with one excel file inside the file, I need to get each excel file from each individual folder and add them to one excel sheet. I have been using the right click activity to unzip files and then a Excel application scope to work with the files.
Question: Is there a easier way of unzipping multiple files in Uipath? Do i have to unzip each files one by one with the right click extract using the click activitites?
- The excel files all have different names but each excel file only has one sheet, I need to extract all the information from that file without having to insert a sheet name.
Problem: I don’t know how to copy the information from the workbook into another excel workbook. I tried the read range activity but it wants me to add the sheet name,i just want to copy the information from each file and combine it into one file without having to tell the robot what sheets, because there is only one sheet in each file so i just need to copy the workbook. I need to combine 27 excel files all into one file without having to add the sheet name. I need all the information from each file. Each sheet name is different for each file. Trying to just extract all the information from the file and write it to another file.
Question: Is there a activity that allows me to just copy the information from the excel file that does not have multiple sheets. Will it allow me to just copy the whole workbook?