Output tool

Question

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.

T_Willins · Answer

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.

anupgupta12 · Answer

Do you know if Alteryx reads macro enabled excel file?

Emil_Kos · Answer

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-single-Excel-file-based-on/m-p/508185/highlight/true#M105325