Add sheet to existing workbook

[Mukeshy12390]

Hi All -

I have created on workflow which generate output and save same output to specific sheet along with existing sheet.

everything work fine. since have to do some formatting to output I had to used "Report Tool" and "Render Tool" but it doesn't work for me.

when I remove sheet name it works but delete all the existing sheet.

could anyone suggest something.

Thanks

Mukesh

[OllieClarke]

Hi @Mukeshy12390 based on a quick search of the community it looks like the Render tool will always overwrite the whole excel file. What you could do (as explained in this thread) is write your data to a hidden 'data sheet' in the excel and then use an Excel template to format it correctly.