Sheet Copy

[Dhiaa-ABM (Art.Abm)]

Hi Guys,
I have to copy excel sheet to other files in many different folders more than 1000 files in folders?
for example:
1-sheet1 in file excel1 inside folder1
2-copy sheet1 to file excel2 inside folder2 + file excel sheet3 inside folder3…etc

[Anil_G (Anil Gorthi)]

@Dhiaa-ABM

Use for each folder in folder and then for each file in folder and use copy sheet inside it …to copy the sheet to each file in each folder

Cheers

[Dhiaa-ABM (Art.Abm)]

I have different file name in different folder name how can I put the path for each one

[balupad14 (Balamurugan)]

Hi @Dhiaa-ABM ,

Take a look at this thread. It helps to solve.

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…

Regards
Balamurugan.S

[mkankatala (Mahesh Kankatala)]

Hi @Dhiaa-ABM

In for each folder in folder activity insert the for each file in folder then copy the sheet from the required excel fil.

I hope it may helps!!

[Dhiaa-ABM (Art.Abm)]

I have more than 1000 file and folder in different name, how can we insert the folder and file path?

[lrtetala (Lakshman Reddy)]

You have to give main folder name it contains 1000’s of subfolders

[mkankatala (Mahesh Kankatala)]

In For each folder in folder you have to give the folder path which contains 1000 of files.

[Anil_G (Anil Gorthi)]

@Dhiaa-ABM

1. I hope all the folders are in a main folder…
2. If yes then for each folder in folder with give you the iteration for all folders inside main folder
3. Then use for each file in folder …you have filter options as well to filter only required using any pttern or extensions

If the structure is different then please let us know more details might help in understanding the pttern if any

Cheers

[Nitya1 (Nitya Tomar)]

Hi @Dhiaa-ABM

Can you try this-

1. Iterate over each destination file/folder where you want to copy the sheet. You can achieve this by using a directory listing activity to get a list of files in the desired folders.
2. Use the “Copy File” activity to create a copy of the source Excel file. Provide the source file path and the destination file path for copying.Use the “Excel Application Scope” activity to open the copied destination file.Add a new sheet: Use the “Add Data Row” activity to add a new sheet to the destination file. Provide the DataTable variable .

Thanks!!