Build 2.9.0.71 of xlsgen adds exposure of table named ranges. Table named ranges are defined names introduced by Excel 2007 (and available in Excel 2010 as well) which are automatically created when the Insert / Table menu function is used in Excel.


Exposure of table named ranges

Technically speaking, the Excel user interface shows the table named ranges in the list of defined names even though they are not stored there at all. Table named ranges are stored in their respective parts inside the file. But, this is convenient for the user. And as a result xlsgen does this as well.

To the developer, table named ranges appear as regular defined names. A new property however is introduced in order to differentiate real defined names from table named ranges (the IsTable property exposed in the IXlsName interface).