Perawat
(Perawat)
July 21, 2020, 8:46am
1
Hi, I have three excel files. I will combine the sheets of all 3 files as the new excel file names. I have the following information.
1150101.xlsx (9.1 KB) 5140104.xlsx (9.3 KB) MB51.xlsx (9.4 KB)
This image is a new excel file that includes each sheet.
Thanks.
Perawat
@Perawat loop over each sheet of each file and Use cooy sheet activity
1996
(Neelima G)
July 21, 2020, 5:57pm
3
Hi @Perawat ,
Can you try below link hope it will help to understand how to move excel sheet to another excel.
Hi All,
I want to copy/move excel sheets to other workbook.
I have checked the link for the excelcopysheet activity, but it is not available in my studio (version 2018.2)
we need the data to be copied with source formatting and we need to copy more than 10 sheets from 4-5 workbook to one workbook.
checked this link as well, but no hope
If solution is working for you please mark it as solution.
Thanks,
Neelima.
balupad14
(Balamurugan)
July 21, 2020, 7:49pm
4
Hi @Perawat ,
Here is an activity called “Copy to file” from balareva.excel.Activities.
Hi Friends,
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
[image]
Create WorkBook
Properties
[image]
Sample : 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…
Here is use case video. Inside I have used this activity.
Regards
Balamurugan.S