TXlsFile deleting tables from excel file?


Just opening and saving an existing excel file (xlsx) makes all table definitions disappear from this excel file. The cell content is still available, but all definitions (and layout) of the tables is gone, and all references and lookups in these tables are invalid.

Simple testcode:

MyXLS := TXLSFile.Create(true);

Am I doing something wrong here?


Is this with FlexCel 6.14?  Support for preserving xlsx tables was added in 6.13, so if your version is older this could be the cause.

Note: In any case, tables are only preserved in xlsx files, since xls files don't support them. They are an xlsx only feature.