Output tool

[anupgupta12]

Hi There!

I am trying to get output of workflow into input file, the input excel file already has 2-3 Sheets, but when I use the same file for output the already exist sheets are removed and only output sheets are available. How do I make sure that my output file does not remove the sheet which already exists.

[Emil_Kos]

Hi @anupgupta12,

Does your output have this configuration as a set-up?

[anupgupta12]

Yes, I  have tried "Create new Sheet" "overwrite" and "Append to existing sheets". None of them is working for me.

For eample

Input file has

input sheet 1     input sheet 2

but output file has

output sheet 1 output sheet 2 

but it does not have input 1 and 2

[Emil_Kos]

Hi @anupgupta12,

do you create a new path to specify the correct sheet name?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-output-multiple-tabs-within-a-s...

[anupgupta12]

Do you know if Alteryx reads macro enabled excel file?

[T_Willins]

HI @anupgupta12,

Yes, Alteryx can read .xlsm (Excel Macro Enabled) files.  It does not read the macros; it brings in data similar to a standard Excel (.xlsx) file.