Excel file path　is corrupted.

I created an Excel file path using Alteryx's formula tool. When I use that file path to create an Excel file using the Data Output tool in an Alteryx workflow, the file looks corrupted.

I will repair it, but I want to avoid it every time, so please tell me the solution.

Comments that appear when you open Excel

Repaired record: workbook properties in the /xl/workbook.xml part (book)

Workflow

Accepted answers

apathetichell

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!

All comments

AbhilashR

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.

apathetichell

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!

SaoriYamguchi

@AbhilashR @apathetichell

Thanks,

Adding to an existing sheet worked fine.

However, this method may retain the previously processed data.

I want to create data so that Excel will not be damaged by either "Overwrite sheet (drop)" or "Overwrite file".

apathetichell

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.

SaoriYamguchi

@apathetichell

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!!!!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703