poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Javen O'Neal" <one...@apache.org>
Subject Re: XSSF and SAX
Date Thu, 04 May 2017 20:52:10 GMT
Take a look at
https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java

On May 4, 2017 12:22 PM, "Mahmood Naderan" <nt_mahmood@yahoo.com.invalid>
wrote:

> Hi,
> I read the document http://poi.apache.org/spreadsheet/how-to.html#sxssf
> in order to read a large excel file. The example in that section left me
> with some questions.
>
> I want to read the cells row by row, so I expect to see/write a nested
> loop for that. The code for reading one sheet is
>
> public void processOneSheet(String filename) throws Exception {
>    OPCPackage pkg = OPCPackage.open(filename);
>                 XSSFReader r = new XSSFReader( pkg );
>                 SharedStringsTable sst = r.getSharedStringsTable();
>
>    XMLReader parser = fetchSheetParser(sst);
>
>                 // To look up the Sheet Name / Sheet Order / rID,
>                 //  you need to process the core Workbook stream.
>                 // Normally it's of the form rId# or rSheet#
>                 InputStream sheet2 = r.getSheet("rId2");
>                 InputSource sheetSource = new InputSource(sheet2);
>                 parser.parse(sheetSource);
>                 sheet2.close();
> }
>
>
>
> As you can see, there is no such thing here. It is stated in the document
> that the reader should be familiar with xml structure. I am not
> unfortunately... What is the outcome of parse()?
>
>
>
>
> Thanks for any feedback.
> Regards,
> Mahmood
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message