Take a look at this; http://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFWorkbook.html#getAllEmbedds%28%29 because, as the tables are embedded, this is the most likely way to retrieve a reference to them.
That method returns a List containing zero, one or more elements of type org.apache.poi.openxml4j.opc.PackagePart which you can then process using POI again - that is assuming they are all Excel workbooks. If you look at the constructor for the XSSFWorkbook class, you will see that one takes a reference to an OPCPackage object and it is possible to retrieve just such an object from the PackagePart by calling it's - that is the PackagePart(s) - getPackage() method. Have never tried it myself but I think that will work. Yours Mark B Sony Antony-3 wrote: > > Hello : > We have an excel workbook in the new XSSF format, with multiple embedded > tables. > When I do a Workbook.getNumberOfNames(), I get zero. > > Is it possible to read embedded tables using POI. > > Any help will be greatly appreciated. > > Thanks > --sony > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/Is-it-possible-to-read-a-table-from-Excel-tp28356078p28356524.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
