December 11, 2019, 1:01pm
I am new to RPA and learner. i want to automate one basic scenario using RPA Automation
– Create one Workbook (Excel_1)
– Copy sheet from other multiple excel (Excel_2, Excel_3 and Excel_4)
– And add all sheets in Master Excel_1
I have created Automation flow but want to confirm that,
is this correct approach what I have created?.. i have used linear process (sequence)
Why am asking is that, for each action I provided DestinationPath, and i didn’t declared this globalpath at any global place and I didn’t apply any loops as well
December 11, 2019, 1:13pm
For instance you have 4 files as File1, File2, File3 and File4 in Input folder and you have to create a master file and copy all files in one.
Use loop for each file
Use read range workbook activity and read sheet into DT
Create and write in master file sheet1 using write range.(Make sheets name dynamic with variable if you need in different sheets else just append)
step 2 to 4 will repeat untill all files are copied.
December 12, 2019, 6:31am
when we read and write, we are loosing Cell Colour, Format…ect (tried this and loosing Formats)
But when copy sheet we can have same format…but again it’s coming without loop
(everytime do i need to mention new sheet)
December 12, 2019, 6:39am
you can create a sample template with the required format and colour you want… In automation just take a copy of that excel file retaining original template as it is and write the data in the copy of excel file.
December 12, 2019, 7:38am
Welcome to UiPath Forum Community !
To Copy the sheet to another file that you can this activity
I have included the below new custom components in the package.
1.Create Workbook.(Create a new worksheet)
2.Copy to File (Copy the worksheet to another excel file).
3.Copy to WorkBook (Copy the worksheet inside the workbook).
4.HideUnhide the worksheet
5.Protect Unprotect the worksheet
CreateWorkbook.zip (18.5 KB)
Copy To File
This activity copies the work sheet to an another excel file. If the another file is not ex…
Video sample :