Excel writer and pivot table

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)

8.17_OrderSOQ.xlsx