Facing Error: Input Data /XML parse failure

[db89]

Hi All,

I am trying to merge all input files with a wild card (" * ") which has same set of names as "Default123" but unfortunately although all of them are ".xlsx" format and not corrupted/do not have any sort of errors, I am getting an error as "Error: Input Data (5): Corrupt File: XML parse failure - cell has no column definition" every time even if I select other files with the same names. 

Can anyone please help me related to the issue as it seems to be not working even if I feedle with the configuration pane. I have attached all screenshots for reference. 

Thanks,

DB

[db89]

@davidskaife yeah! i selected the entire set of columns and converted to text. But still getting that error! Weird.

[davidskaife]

@db89 must be something else in that file that is causing the error, at least 8 of the 9 files now work! Sorry i couldn't help get to the bottom of the overall issue

[apathetichell]

bring the file that won't go in via wildcard via a separate input data tool. compare columns. you will have one that is different. even if it is an extra column without data.

It's much more stable to bring in multiple files via a batch macro. the wildcard method really needs perfect schema to work.

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