Local excel files automation - multiple sheets but 1 file problem (saving to multiple sheets in 1 file)

[skajer]

Hello everyone,

I’m trying to build a workflow that processes some data and then saves it to different sheets within a single local Excel file .

For example, I want to take data from Step 1 and append it to “Sheet A”, and then take data from Step 2 and append it to “Sheet B”, all within the same main_file.xlsx.

My problem is that I can’t figure out how to do this. Every time I use the Microsoft Excel node to write data, it seems to create a completely new file instead of updating the existing one.

The only workaround I’ve been able to come up with is to save the data to a separate, new file each time. This works, but it’s not the solution I’m looking for, as I need all the data consolidated in one main file.

Is there a way to configure the node to append data to a specific sheet in an existing local file? How can I handle writing to multiple different sheets in the same file within a single workflow?

’ve tried to use nodes such as:

“Conver to file”
“Write spreadsheet file”

but none of these work. Can someone provide me with working workflow that will save some data (lets say 2 items) in the same file of excel but in 2 different sheets?

Any help or guidance would be greatly appreciated!

Thank you.

[Visnja]

Hey Skajer, would you mind sharing your workflow? Specifically check if your node is appending the data to an Excel workbook or worksheet? Thanks!

[skajer]

this is part of the flow. I’ve tried to use the loop node. But it gives me several different files.

[Visnja]

Thank you for sharing that, it’s really helpful. Would the logic still work if you did something like this?

So instead of doing a loop, maybe have an if flag that checks if the spreadsheet exists.
If this statement is false, create a new spreadsheet and add the data in the sheet.

If the statement is true, then add the data to a new sheet in the already existing spreadsheet.

Thanks,