Copying All Sheets from a Repository to Excel Split Files Issue

[themarkknight19]

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!

[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.

[atcodedog05 · Accepted solution]

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.

[atcodedog05]

Hi @themarkknight19 ,

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

Thanks : )

[themarkknight19]

Hi @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!

[atcodedog05]

Hi @themarkknight19 

Maybe i ask what is the order it is in now?

[themarkknight19]

Hi @atcodedog05,

It is in this order currently:

Contract Item Information

Item Attributes

Contract Header

Header Attributes

Thanks!

[atcodedog05]

Hi @themarkknight19 ,

I tried a couple of available ways but it seems i am not able to change the sort order.

I will let you know if i find any.

[atcodedog05]

This is being caused by the different execution time

[themarkknight19]

Thank you so much on this!

Hopefully we can reorder the sheets as this is really important when the files are loaded in a system.