On Tue, 22 Feb 2011, Donato wrote:
I saw that if you save the Excel file as xlsx, the table definition is put in the table1.xml file under xl/tables.
There's some support for this in XSSF. The trick to spotting support for these things is to first look in XSSFRelation, where you'll see that handily we know about it as XSSFRelation.TABLE. Next, ask your IDE for references to that, and in this case it's in XSSFMap via the getRelatedTables() method. That'll return you a Table object, which is a wrapper around the various low-level xmlbeans objects. You get at the maps via getCustomXMLMappings() on a xssfworkbook.
Hopefully that's enough to get you going? Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
