topic Re: Writing data into multiple sheets of same excel output file in Alteryx Server Discussions

Writing data into multiple sheets of same excel output file

RAMN — Tue, 09 Jul 2019 16:57:59 GMT

Hi,

I am looking for a solution to write multiple sheets into same excel file, that are coming from different sections in the workflow. Will alteryx throw any error if I use overwrite sheet option and use different output tools for different sheets.

For example, for 3 data sections in the workflow, I use 3 output tools with sheet1, sheet2, sheet3 of FILE1 and taken overwrite sheet option in the output settings.

Regards,

Ram

Re: Writing data into multiple sheets of same excel output file

jamielaird — Tue, 09 Jul 2019 17:35:59 GMT

Hi @RAMN

You will probably find that the 2nd and 3rd outputs return errors as the 1st output will have locked the Excel file while writing to it.

The easiest solution is to use a Block Until Done tool and structure your workflow so that your multiple Output tools are in streams that branch from different numbered outputs of this tool.

This approach is described here:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-write-to-multiple-tabs-separately-without-errors/ta-p/33413