Copying All Sheets from a Repository to Excel Split Files Issue

I have a repository excel file that I need to split into separate excel files where the Outline Agreement ID is the key.

I have 2 workflows that I got from a person that also did the same process but I couldn't make it work properly for my end.

I already edited the workflow and put all of my files and paths. And when I run it, it does the splitting of excel files but it does not copy all of the sheets/tabs from the repository to the split files.

The repository has 4 tabs/sheets but the output split files only contain 2 of the 4 tabs/sheets from the repository.

I need all of the 4 tabs from the repository to the split files.

I am also encountering this error when I run the first workflow: "...returned an error code: 1: The operation completed successfully. (0)"

I have attached my workflows and the files that are needed to run.

Hoping you can assist me with this as this is high priority in my project

Thank you very much!

All Files.zip

Workflow

Input

Transformation

Accepted answers

atcodedog05

Hi @themarkknight19 ,

I took a look at your sample output. Since Column "Contract Header" and "Header Attributes" have any rows knew it was not a straight forward.

After working a while i was able to come up with a workflow.

This creates a file with Agreement ID with all 4 sheet. Check the sheet list

I hope this meets your requirement. Please check and let me know.

If there is any other issues or concerns reply on this post and tag my name by using @ i will get back to you.

I have attached the files.

All Files v2.zip

All comments

atcodedog05

Hi @themarkknight19 ,

Here i have fixed the first workflow. I am using relative addressing instead of absolute.

Considering all the files are in the same folder. I will work 2nd workflow.

Please check this and let me know.

If you are still facing issues tag my name and reply on the post.

01_Create ID - XE_v3.yxmd

atcodedog05

Hi @themarkknight19 ,

I took a look at your sample output. Since Column "Contract Header" and "Header Attributes" have any rows knew it was not a straight forward.

After working a while i was able to come up with a workflow.

This creates a file with Agreement ID with all 4 sheet. Check the sheet list

I hope this meets your requirement. Please check and let me know.

If there is any other issues or concerns reply on this post and tag my name by using @ i will get back to you.

I have attached the files.

All Files v2.zip

atcodedog05

Hi @themarkknight19 ,

If this helps can you please mark the post as solution.

Thanks : )

themarkknight19

atcodedog05,

Oh my god, thank you very much!

It works now on my end, I can see the that the 4 sheets are in the split files.

I can't thank you enough for making the effort to think about this.

I have one final question left.

How can I reorder the sheets in the output split files?

The order of the sheets should be the same as in the input file (SHL test service 2.xlsx)

Contract Header

Contract Item Information

Header Attributes

Item Attributes

Again, thank you very much!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703