If we read data from an excel file from sheet1 then how to write data as sheet2 in the same file?
As if we used sheet1 from the file and after doing some aggregation, manipulation, pivoting I need to write the file in the same file with different sheet-like sheeet2, sheet3,…
to do so you can use the Excel Writer node. Select the existing excel file as output location (either manually or via a flow variable) and select append. Then define the name of the new sheet below.
Depending on your use case you could also add additional input ports to the excel writer by clicking on the three dots in the bottom left corner of the node. This allows to writer several sheets in one go
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.