.xls Output File
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @danilang.

- « Previous
-
- 1
- 2
- Next »