Axolot Data

Hello,

I have an Excel-File consisting of 3 sheets. I read the file and everything is fine. Then I change the sequence of rows in one sheet and save it again.
On reading I get an error message:
"Error on reading record # 4, 005C Offs: 00000098"
etc.

What does that mean? I would like to know in which sheet is the error, in which line, which column.

The "corrupted" Excel-File can be opened without error message in Excel.

Sincerely

Peter

Hello,

Maybe I have found the culprit for many exceptions opening Excel-files in XLSWrite Version 4.00.45.
For the component exists a property UserName. I never have been using it. But on all XLSWrite Components
there is a value in the dfm-Text like this:
UserName = 8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#8224#12340#13360'12~'#0'ineEnu' +
'merations.MapType; const Col, Row: cardi'

In the PropertyEditor it looks like this:

UserName ††††††††††††††††††††††††††††††††††††††††††††††††††††〴㐰52~

I have no idea, where this values come from? Maybe from upgrade of the components?

After removal of all UserName occurences in the dfm-files, everything seems to work fine.

Hopefully the exception will not come back?

Sincerely

Peter

Hello

You may get this error when reading files not created by excel. Is that the case here?