XML Parse Failure - cell has no column definition

[kcoleman]

I'm trying to combine a bunch of excel files into one file, but i'm getting the below errors when they're read in. Any ideas? All files should have the same tab name (Sheet1) and the same number of columns.

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

[NazK]

Hi,

I just ran into the same issue and another issue where I cannot see the sheets inside the file with .xlsx extracts from a source.

Saving the file again and if you have multiple files using something to do it automatically in a loop should help.

Also, long shot, have you had a look at this: Access Driver Install for .xls File Acess - Alteryx Community