Hi,
I am using a .xls file as an output file for one of my projects. The issue here is that, I'm using a reference file for the Output tool and that file has multiple sheets, I want to overwrite the data from Alteryx to one of those sheets. I tried selected 'Overwrite Sheet' and 'Delete Data and Append' options but every time Alteryx is creating a new sheet by adding a suffix as '1' to the sheet name.
For eg. : if the reference file has a sheet name as ABC then Alteryx is creating a new sheet with the name 'ABC1'. I want Alteryx to overwrite this ABC sheet only. Lastly, I cannot change the format of the file to .xlsx or .xlsm since the Client has strictly asked to stay with .xls format only.
Please guide me on what I should do here.
Thanks.
