In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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