Adding Sheet in existing file using output data corrupts file

Question

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 ?

Quality Area Database.xlsx

Query Final por Tx 51  SCRAP Controller _ 1328289 _ 2218960.xlsx

Quality Scrap Report.yxmd

Quality-Scrap 2021 Agosto W#2.xlsx

JagdeeshN · Accepted Answer

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 Answer

Hi @JagdeeshN,

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

Best,

Victor

Victouf · Accepted Answer

Hi @JagdeeshN,

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

Best,

Victor