Ahh perfect, Thank you this is what I was looking for, I am pretty new to this only started using it a couple of weeks ago so don't know everything available.
Many thanks Richard On 16 March 2010 15:43, Nick Burch <[email protected]> wrote: > On Tue, 16 Mar 2010, Richard Holmes wrote: > >> So for me the following worked >> 1) Load the Excel Workbook as normal for processing. >> >> *this*.filesystem = *new* POIFSFileSystem(excelInputStream); >> *this*.workbook = *new* HSSFWorkbook(*this*.filesystem); >> >> 2) Register a read listener on the Root directory for an entry called XML, >> > > Why do you need to use the listener interface? Why not just get it all > directly? > > eg > > POIFSFilesystem fs = new POIFSFileSystem(inp); > HSSFWorkbook wb = new HSSFWorkbook(fs) > InputStream xml = fs.createDocumentInputStream("XML"); > // SAX/Dom parsing of the xml follows > > Nick > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
