Axolot Data

I'm having trouble loading range names using the new XLSX format. XLS works fine, but with an XLSX file I always get an error. All of the names can be found in XLS.InternalNames, but for each one FNameDef is nil, and consequently NameIsArea and NameIsCell always return False. If I try to access the row or column coordinates then the exception 'Name is not of requested type.' is raised. I have v 4.00.35.

Hello

Names are not completely implemented in excel 2007 files yet. You can however read a names definition from the NameDefStr property.
Example: ShowMessage(XLS.InternalNames[0].NameDefStr);

Don't do any changes to NameDefStr!