Cannot read XL2007 files with5.10.23

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
taz.higgins
Posts: 8
Joined: Wed May 29, 2013 2:57 pm

Cannot read XL2007 files with5.10.23

Post by taz.higgins »

Just upgraded 4 to 5. Files I can open with V4 fail to open with V5 with the following error

E1001: XML read error: "Row 0: Unknown Attribute "xmlns""

Looks like you need to handle this attribute in TCT_Sst.AssignAttributes.
An unknown attribute should not prevent opening a file, in fact I think it should be ignored not raise an error
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Cannot read XL2007 files with5.10.23

Post by larsa »

Hello

True. Unknown attributes and other XML errors are now (in the next update) warnings. Before 5.10.23 errors never raised an exception. Sometimes this can be usefull, for example when reading an encrypted file and the password is missing or incorrect.

You can still read the file if you set: XLS.Errors.SaveToList := True;
Errors and warnings will then be in the XLS.Errors.ErrorList property.
Lars Arvidsson, Axolot Data
Post Reply