Alteryx Corrupt File Error Message

Question

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!

Sarath27 · Answer

Hi,

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

Joaodasilva · Answer

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

Thanks for the tip

MaciejG · Answer

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 osfrom openpyxl import load_workbookfrom 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)