How to convert multiple worksheets to multiple excel files

[foppishinc]

There are two worksheets ‘ABC’ and ‘XYZ’ in the Summary file. I just wanted to extract them into 2 excel files ‘ABC’ and ‘XYZ’.

I already have a workflow done up but it only works on my computer but not for the others as I’m not sure where the output files went to.

Sheets to Workbook.zip (16.2 KB)

[Nadia_GHOUFA]

Hello,
The path to the generated file in your workflow is local so if you put the full path to where you want to store the output it will work. for exemple in your workflow you can do like in the screenshot.

Kindly,
NAD.

[foppishinc]

@Nadia_GHOUFA hey, the expression did not work for me.

[prasath17 (Guru)]

@foppishinc - Since there is no path given , it is by default write to the project folder…i.e where your xaml and json is…

So please check under the project folder on the new machine…

[balupad14 (Balamurugan (BalaReva))]

Here is an activity called “Copy to file” that it copies the sheet into a file.

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

[Nadia_GHOUFA]

Exactly, so you can find them in the project folder or specify a full path to the location where you want to put your files.

[foppishinc]

@Nadia_GHOUFA I understand but the expression that you have shown in the screenshot does not work.

[Nadia_GHOUFA]

Do you have access to C:\ in the work machine? if so what’s the error ? The output of your workflow is something like this :

Make sure to put a path that is accessible.