Output repair error

Carlyn

Hi, I keep getting a repair error when opening my output file and it appears to be relating to one particular output in my model.

I have checked the fullpath and the output and it all looks correct but I can't seem to resolve the error. I have attached some screenshots incase its any help.

The details of the error are 'The name in the end tag of the element must match the element type in the start tag. Line 374, column 2604'

Does anyone know how I identify what the line and column numbers refer to?

Output repair error.docx

KGT

The error that you are receiving is related to the ooxml format that underpins XLSX files. If you really want to investigate that, then unzip the xlsx file (yep that simple), and then look for calcChain.xml and look for line 374.

However, I have seen this type of error when writing to xlsx and quoting the sheetname in different ways. It used to be standard to quote the sheetname as 'sheetname$', but that causes errors with the current excel drivers sometimes. So, check the way the sheetname is referenced in the output tool first.