Excel File Corrupt After Writing to Excel Range

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!

Output

Accepted answers

fmvizcaino

Hi @zrotuno ,

As I remember, there was a bug related to writing to excel range when skipping field names that would generate this kind of excel corruption.

Best,

Fernando Vizcaino

fmvizcaino

Hi @zrotuno ,

I've just checked and the new version 2020.2 has this bug fixed already.

Best,

Fernando Vizcaino

All comments

fmvizcaino

Hi @zrotuno ,

As I remember, there was a bug related to writing to excel range when skipping field names that would generate this kind of excel corruption.

Best,

Fernando Vizcaino

zrotuno

Thank you @fmvizcaino ! I went ahead and unchecked that box and created a work around in my Excel file and that did the trick. Although it is not ideal (I have to hide a row) it does the trick.

Has there been a mention of a possible update to correct that bug?

Thank you!

fmvizcaino

Hey @alison ,

I saw this same error recently and it was related to special characters in the sheet name. Not sure if it is your case.

Best,

Fernando Vizcaino

alison

Fernando, thanks for the tip. Didn't really apply to my file but it was worth the look!

Interestingly, it only happens when this workflow is run from a schedule, not when I kick it off manually from gallery or run it in designer (or maybe it's just been lucky timing, lol).

TaraA

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703