XML Parse Failure - cell has no column definition

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.

Workflow

Accepted answers

All comments

Should add, the initial file reads in fine in the Macro...!

Are you able to read them individually?

Give this macro a try.

Hope this helps : )

Multiple Excel Sheets Multiple Files.yxzp

The directory reads them in fine it seems, but your red tool here gives the same errors as before!

Don't think that's my issue, but thank you.

Can you provide a sample file with the issue so that we can look into it?

Have attached two sample files from the sets I'm working with!

EXPORT Sample File 1.xlsx

EXPORT Sample File 2.xlsx

Set the start data import on line as 2. And give this a try its working for me.

Hope this helps : )

No change when trying to combine files. Have you been successful there?

Hi @kcoleman

I was able to pull in files with the attached config.

Hope this helps : )

I give up! 😆

But it worked for your sample file though 😅

Hi, I have just experienced the same problem. According to a reply from Excel Input Error - Alteryx Community. I have verified that the file could not be read via any applications other than excel, which I believe that there are some types of problems with the file itself but not with Alteryx. In the reply from the other post, explanation is 'I was told that the software that was building the original Excel file was using a library that wasn't compatible with other applications'. The problem is solved in my case after I reopened the file and resaved via Excel.

This was the solution for me as well, thank you for sharing!

Hi @kcoleman ,
I am facing the same problem,I need to save the excel generated from other source before i need to run it
Did you managed to find a solution for this

Yes, by saving the file as a .xlsx on my desktop and then working with it in Alteryx I was able to get around this issue.

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)

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703