Adding Sheet in existing file using output data corrupts file

[Victouf]

Hi,

I run a workflow that is supposed to add a sheet within an existing excel file. Whenever I run the workflow this sheet is added but the file is corrupted and formatting and data are changed/deleted from the file. Did this ever happen to anybody ? 

[JagdeeshN · Accepted solution]

Hi @Victouf ,

I am not sure why the file is getting corrupted. My best guess is that it is because of the need to Update Links within the excel file.

One quick workaround is to have an empty sheet named 'Query' within the excel. In the workflow itself, instead of creating a new sheet use the overwrite option.

Please find attached the updated workflow and the updated excel file.

Hope this helps.

Best,

Jagdeesh

[Victouf · Accepted solution]

Hi @JagdeeshN,

Thanks a lot, it helped to solve the issue of the corrupted file. 

Best,

Victor

[Victouf · Accepted solution]

Hi @JagdeeshN,

Thanks a lot it helped to solve the issue of the corrupted file.

Best,

Victor