Parse Error When Connecting to XLSX File

[Chris_]

I have a MS Excel xlsx file I'm trying to bring into Alteryx and whenever I connect to it I get the following error:

"Corrupt File: XML parse failure - cell has no column definition"

However, I have no issues opening this file in MS Excel or other ETL toolsets. 

The file has about 15 tabs, no special characters in worksheet or workbook names, and no merged columns/rows. 

This file is an auto-export from a source system and the only format that is available is xlsx.

Any thoughts would be very helpful.

[AndrewPowell]

Appreciate this thread is now getting a bit old but just had the same issue with a file before realising there was a group set on the rows in the worksheet.  Ungrouped in Excel, saved and and the file imports fine.

Not going to be the case for every file that fails to import of course but thought I'd add this in case it helps anyone else.

[ankur13agrawal]

Hi,We are facing the same error,did you managed to  find a solution for this

[ankur13agrawal]

Hi
I am facing the same error,did you managed to find a solution for it

[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)