Local excel files automation - multiple sheets but 1 file problem

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

Any help or guidance would be greatly appreciated!

Thank you.

[King_Samuel_David]

Hey @skajer

feel free to shareworkflow,

and your need like an edit or upsert function not create, create will make new.

Also I think selecting which sheet to add data too is under the options on the node, so worth looking there too.

Please share and can help advise further.

Samuel

[skajer]

I’ve tried to use nodes such as:

“Conver to file”
“Write spreadsheet file”

but none of these work. Can you 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?