Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Excel File Corrupt After Writing to Excel Range

zrotuno
6 - Meteoroid

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:

 

zrotuno_1-1591272529565.png

 

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.

 

 

zrotuno_0-1591272479515.png

 

When I run the workflow it runs successfully without errors however when I go to open the file I receive the following errors:

 

zrotuno_2-1591272687376.png

zrotuno_3-1591272700823.png

 

zrotuno_4-1591272730657.png

 

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:

 

zrotuno_5-1591272838169.png

 

 

I receive the same Excel File Errors when I select the "Overwrite Sheet" option:

zrotuno_6-1591273248200.png

 

 

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! 

 

10 REPLIES 10
TaraA
7 - Meteor

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?

 

Labels
Top Solution Authors