Alteryx Corrupt File Error Message

[gianna_albano]

Hello,

I’m trying to run an input data tool in a workflow and receiving the following error message: “Corrupt File: XML parse failure – cell has an invalid row definition.”

Please Note: the file is saved as .xlsx and when opening in Excel, it opens fine.

Any help would be appreciated. Thank you!

[Luke_C]

Hi @gianna_albano 

Some of the suggestions in this thread may be helpful:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Parse-Error-When-Connecting-to-XLSX-Fi...

[Prashansha_22]

Hello,

Some of the reasons behind this error are:

∙ Unexpected power failure during the editing of Excel sheet

∙ Excess data storage in a single Excel file

∙ Bad sector in the Excel workbook

∙ Damaged CSE Formulas and Excel Macros

∙ Due to the sudden closing of the opened Excel workbook

∙ Unexpected Excel crash

So, when excel detects any corruption in a file, it automatically suggests recovering the file, But if it doesn’t shows then use excel inbuilt compact and repair utility:

Please visit the below URL to repair the corrupted file:

https://support.microsoft.com/en-us/office/repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd... 

https://social.technet.microsoft.com/Forums/SECURITY/en-US/e5692c4a-924d-44a5-985b-7878f3eb26de/corr... 

Best Regards,

Prashansha

[MaciejG]

Try opening and saving all of the files that are giving you this error.
Here is a quick python loop to do that for you (you can also do it manually if there are just a few files):

import os

from openpyxl import load_workbook

from openpyxl.workbook.workbook import Workbook

folder_path = "your folder path"

for filename in os.listdir(folder_path):

    if filename.endswith(".xlsx"):

        file_path = os.path.join(folder_path,filename)

        wb = load_workbook(file_path)

        wb.save(file_path)

[Joaodasilva]

Opening and re-saving the input doc has fixed my issue. 

Thanks for the tip

[Sarath27]

Hi,

Could you please kindly post the solution for this issue? It would be really helpful.