Excel File Corrupt After Writing to Excel Range
- 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
Hello Everyone,
I have researched this issue on the Community however I cannot find a solution that works for me. I am attempting to write to an .xlsx file to a specific range. I created the Excel File and then specified the range where I want the data to be written:
Below is how the file is going to be structured (example is only first 3 columns) for use by my customers. Row 4 headers are customized to stay and then I write the data below that row.
When I run the workflow it runs successfully without errors however when I go to open the file I receive the following errors:
When I eventually go through the prompts and open the file, some of the data I have entered has disappeared and the grid lines are showing again:
I receive the same Excel File Errors when I select the "Overwrite Sheet" option:
Am I missing something here? Looking forward to receiving feedback. I am currently using Alteryx Version 2019.4.8.22007 however we do plan to update to the new version soon so not sure if a fix for this has been released in a more current version.
Thanks!
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm using version 2023.1.1.361 and it only happens when run from the scheduler. It does not happen from the desktop. Has there been a resolution?

- « Previous
-
- 1
- 2
- Next »