Excel Input Error

Question

I'm trying to input an excel file (.xlsx) but I keep getting the following error

"Corrupt File: XML parse Failure  cell has no column definition"

If I open the file and delete the first row, I'm able to input the file.  While this isn't that inconvient when dealing with one file, I have dozens of files in the same format that have this issue.  Is there any way to bypass the first row on input?

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)

AIChudnovsky · Answer

The first time I experienced a similar issue, I also had issues opening the same file in other third-party applications like Python and even Excel's Spreadsheet Compare App.  The only place I was able to successfully open the file was Excel.  The way I was able to resolve this issue was by opening the file and resaving it with no other changes.  I was told that the software that was building the original Excel file was using a library that wasn't compatible with other applications.

I just experienced this same issue with an .XLSX file that was generated by TD Ameritrade for my investment holdings.  I was able to resolve this issue with the same approach of opening the file and resaving it in Excel.

Obviously if you have many files to read in, this won't be a viable solution, so you'll need to build a bot (e.g., using Python) that opens and saves all of your files prior to using them in Alteryx.

asifk · Answer

Hi

I am also encountering this error even after installing the Microsoft Access as per above.

However i notice that if i read in the file as Microsoft Excel Legacy, it reads in successfully however the entire worksheet contains nulls which is not the case.

Please can someone look into this, i have tried searching and reading  through treads but found anything that can assist me

Regards,

Asif