File corrupted by XLSReadWrite Version 4.00.45 at Delphi XE

[PStadler]

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

[PStadler]

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

[larsa]

Hello

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