Excel Writer, not able to update multiple sheets data every time

Hi Team, i am trying to update/overwrite the excel writer node, which has multiple sheets.
Source Snowflake: writing data to excel.
Nuance: this excel also have some other sheets too, which i do not want to remove of change.

  1. Everytime i need to run periodically to get the updated data. if i do overwrite, its overwriting with the updated data, but removing other worksheets too. which i do not want.
    is there any other workaround for this?

Hi @dgambhir , how have you got your Excel Writer configured? If I’m understanding your problem correctly, you will need to have it configured to “append” rather than “overwrite” the file.

2 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.