Workflow with multiple excel sheet extraction

[atti_effe]

I have a workflow that in parallel mode extract data from different sources, at the end it writes on an excel file with multiple sheet. The name of the file is always the same so “extraction.xlsx”, the problem is in the Excel Writer node because i don’t know how to configure the “overwrite file” and “append sheets”, thats because i don’t know which node will be executed as first.

So, not knowing which one will be the first, i don’t know where to put the “overwrite file” choice that should be done initially. This can be solved using one empty Excel Writer that write on a empty sheet and overwrite the file.

I also noticed, and this is the most important issue, that probably if many node are writing different sheet on the same file at the same time one of them won’t work properly (i usually find some sheet missing).

So at the end i cannot use this multiple sheet excel file because of sync problems.

Have you a best practice for this?

[ArjenEX]

Hi @atti_effe

Assuming this is a simplefied version of your setup, I would opt to connect all the Excel Writers to eachother in sequence. This ensures that they wait for the connected node to be executed first.

The first node in line can be then set to override the files while all subsequent nodes append that file. As such, if I want to execute the lower writer, it simultaneously also executes the upper writer first.

[mlauber71]

@atti_effe flow variables are a good way to organize the flow of data. Another option if you use a loop is to overwrite the Excel file in the first iteration:

Group Loop Not working with sheets renaming

@r_jain you could overwrite the Excel file in the first loop and then append the other sheets in the following ones: [image] Download the whole workflow group.