Excel writer and pivot table

[Subramanyam]

Hi Team,

I am writing data to an excel file which consists of two sheets
Sheet1 – which we need to update the data by the workflow.
Sheet2 – Pivot table which will get refresh with the data in sheet1.

But when I am writing the data to sheet1 with overwrite option it is completely replacing the Excel File and Sheet2 is missing.

Please suggest me how to overcome this issue.
Attaching the sample data
First attachment consists of Pivot table in Sheet2
Second Attachment consists of data need to be upload into sheet1.
Please treat this as urgent.

Thanks,
Subramanyam Kinthada.
[01.03.23_OrderSOQ.xlsx|attachment] – (upload://vR9xJaOECcQ7YBNy1OaBF6JhWy4.xlsx) (3.8 MB)
8.17_OrderSOQ.xlsx (2.5 MB)

[Subramanyam]

attaching Excel sheet that consists of Pivot table data.
01.03.23_OrderSOQ.xlsx (3.8 MB)

[mlauber71]

@Subramanyam you will have to append to the file and overwrite the sheet

KNIME and Excel — An Overview of What You Can Do

[Subramanyam]

it worked thanks a lot