Excel file path is corrupted.
- 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
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @SaoriYamguchi, can you try to replace your existing output file with a brand new file (maybe a .xlsx file) and try using your approach? I've tried doing this once in the past which I vaguely remember addressing this issue. Seems like your existing output excel file has some existing properties that seem to be causing this issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think your filepath wasn't correct when you initial built the file. Can you check if every worksheet is included. Do any of your worksheets include spaces or other special characters? It may be that you've described them just in the |||worksheetname - but you need to use |||`worksheetname$` - or it also could be that you are calling your range incorrectly - or perhaps you are trying to ouput data after rendering?
Usually you can tell which worksheet generated this error and then trace back to what is incorrect in the path being passed in.
One other note - once the XML is damaged you will always get that message - so delete or rename the original and restart!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
was this file created via the render tool? assuming the answer is no - both overwrite sheet and overwrite file should have no effect on whether the xml gets damaged. are you changing the filepath?
Can you share the config of your output data with a sample of any paths being fed in? that's usually the source of this kind of error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, I read your comment again.
The sheet name was enclosed in single quotes. That was the cause.
After removing the single quotes from the sheet name, Excel is no longer corrupted.
THANKS!!!!!
