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.
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
Do you know if Alteryx reads macro enabled excel file?
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.