I know this post is old, but we experience this problem and I wanted to provide a few detail which might help someone in the future. We have a workflow that picks up a spreadsheet, archives it as-is, updates it with the latest data from a database and writes it out. This is repeated three times a day. After running hundreds of times, suddenly we received this error:
Internal error in Xerces parser for Sheet Metadata: expected end of tag 'row'
If I altered the file extension of the problem file to .zip and opened the relevant xml file (that represents the problem worksheet) then saved it elsewhere, trying to read it via Alteryx would result in a similar error referring to column 3, line 3.
I finally tracked the problem down. The last good record in the xml file looks like this (I've simplified)
<row r="11495" spans="1:32" x14ac:dyDescent="0.55000000000000004"><c r="A11495" s="1">
<v>2024</v></c><c r="B11495" s="1"></c></row>
but the next one is like this:
<row r="11496" spans="1:32" x14ac:dyDescent="0.55000000000000004"><c r="A11495" s="1">
<v>2024</v></c><c r="B11496" s="1"></c>
It is missing the 'closing' </row> tag. From that point onwards, there are no 'opening' or 'closing' row tags. So when alteryx previously wrote the file out, it had some kind of glitch - it was able to write the file but it was garbage. We were able to take an old archived version of the file, prior to the problem occurring and put it in place of the problem file - the workflow would then run without issue.
Having checked the data we are pulling from the database in to the file, there are no special characters or anything in the final 'good' record or the record where the problem starts...I am just putting it down to an obscure alteryx bug.
