blocks|key|203855|text|Apache+POI+framewor是最佳选择-+link|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|203856|它的event-based-api有助于最好的内存优化|203857|如果实现得当，它可以处理更大的excel工作表，如here所示|203858|读取大文件的|203859|示例：|blockquote|203860|203861|203862|++++public+void+parseExcel(File+file)+throws+IOException+{

++++++++++++OPCPackage+container;
++++++++++++try+{
++++++++++++++++container+=+OPCPackage.open(file.getAbsolutePath());
++++++++++++++++ReadOnlySharedStringsTable+strings+=+new+ReadOnlySharedStringsTable(container);
++++++++++++++++XSSFReader+xssfReader+=+new+XSSFReader(container);
++++++++++++++++StylesTable+styles+=+xssfReader.getStylesTable();
++++++++++++++++XSSFReader.SheetIterator+iter+=+(XSSFReader.SheetIterator)+xssfReader.getSheetsData();
++++++++++++++++while+(iter.hasNext())+{
++++++++++++++++++++InputStream+stream+=+iter.next();

++++++++++++++++++++processSheet(styles,+strings,+stream);
++++++++++++++++++++stream.close();
++++++++++++++++}
++++++++++++}+catch+(InvalidFormatException+e)+{
++++++++++++++++e.printStackTrace();
++++++++++++}+catch+(SAXException+e)+{
++++++++++++++++e.printStackTrace();
++++++++++++}+catch+(OpenXML4JException+e)+{
++++++++++++++++e.printStackTrace();
++++++++++++}

++++}

++++protected+void+processSheet(StylesTable+styles,+ReadOnlySharedStringsTable+strings,+InputStream+sheetInputStream)+throws+IOException,+SAXException+{

++++++++++++InputSource+sheetSource+=+new+InputSource(sheetInputStream);
++++++++++++SAXParserFactory+saxFactory+=+SAXParserFactory.newInstance();
++++++++++++try+{
++++++++++++++++SAXParser+saxParser+=+saxFactory.newSAXParser();
++++++++++++++++XMLReader+sheetParser+=+saxParser.getXMLReader();
++++++++++++++++ContentHandler+handler+=+new+XSSFSheetXMLHandler(styles,+strings,+new+SheetContentsHandler()+{

++++++++++++++++@Override
++++++++++++++++++++public+void+startRow(int+rowNum)+{
++++++++++++++++++++}
++++++++++++++++++++@Override
++++++++++++++++++++public+void+endRow()+{
++++++++++++++++++++}
++++++++++++++++++++@Override
++++++++++++++++++++public+void+cell(String+cellReference,+String+formattedValue)+{
++++++++++++++++++++}
++++++++++++++++++++@Override
++++++++++++++++++++public+void+headerFooter(String+text,+boolean+isHeader,+String+tagName)+{

++++++++++++++++++++}

++++++++++++++++},+
++++++++++++++++false//means+result+instead+of+formula
++++++++++++++++);
++++++++++++++++sheetParser.setContentHandler(handler);
++++++++++++++++sheetParser.parse(sheetSource);
++++++++++++}+catch+(ParserConfigurationException+e)+{
++++++++++++++++throw+new+RuntimeException("SAX+parser+appears+to+be+broken+-+"+%2B+e.getMessage());


}|code-block|syntax|javascript|203863|entityMap|0|LINK|mutability|MUTABLE|url|http://poi.apache.org/|1|http://poi.apache.org/spreadsheet/how-to.html#event_api|2|https://stackoverflow.com/questions/4897766/processing-large-xlsx-file-in-java^0|Q|4|0|0|2|F|1|0|P|4|2|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@$A|1A|B|1B|1|1C]]|C|$]]|$1|F|3|G|5|6|7|1D|8|@]|9|@$A|1E|B|1F|1|1G]]|C|$]]|$1|H|3|I|5|6|7|1H|8|@]|9|@]|C|$]]|$1|J|3|K|5|L|7|1I|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]|$1|N|3|-4|5|6|7|1K|8|@]|9|@]|C|$]]|$1|O|3|P|5|Q|7|1L|8|@]|9|@]|C|$R|S]]|$1|T|3|-4|5|6|7|1M|8|@]|9|@]|C|$]]]|U|$V|$5|W|X|Y|C|$Z|10]]|11|$5|W|X|Y|C|$Z|12]]|13|$5|W|X|Y|C|$Z|14]]]]

Apache POI framewor is best choice - <a href="http://poi.apache.org/" rel="nofollow noreferrer">link</a>

It's <a href="http://poi.apache.org/spreadsheet/how-to.html#event_api" rel="nofollow noreferrer">event-based-api</a> helps best memory optimization

It can process larger excel sheets if implemented properly as shown <a href="https://stackoverflow.com/questions/4897766/processing-large-xlsx-file-in-java">here</a>

<blockquote>
 Example Reading large files:
</blockquote>

<pre><code> public void parseExcel(File file) throws IOException {

 OPCPackage container;
 try {
 container = OPCPackage.open(file.getAbsolutePath());
 ReadOnlySharedStringsTable strings = new ReadOnlySharedStringsTable(container);
 XSSFReader xssfReader = new XSSFReader(container);
 StylesTable styles = xssfReader.getStylesTable();
 XSSFReader.SheetIterator iter = (XSSFReader.SheetIterator) xssfReader.getSheetsData();
 while (iter.hasNext()) {
 InputStream stream = iter.next();

 processSheet(styles, strings, stream);
 stream.close();
 }
 } catch (InvalidFormatException e) {
 e.printStackTrace();
 } catch (SAXException e) {
 e.printStackTrace();
 } catch (OpenXML4JException e) {
 e.printStackTrace();
 }

 }

 protected void processSheet(StylesTable styles, ReadOnlySharedStringsTable strings, InputStream sheetInputStream) throws IOException, SAXException {

 InputSource sheetSource = new InputSource(sheetInputStream);
 SAXParserFactory saxFactory = SAXParserFactory.newInstance();
 try {
 SAXParser saxParser = saxFactory.newSAXParser();
 XMLReader sheetParser = saxParser.getXMLReader();
 ContentHandler handler = new XSSFSheetXMLHandler(styles, strings, new SheetContentsHandler() {

 @Override
 public void startRow(int rowNum) {
 }
 @Override
 public void endRow() {
 }
 @Override
 public void cell(String cellReference, String formattedValue) {
 }
 @Override
 public void headerFooter(String text, boolean isHeader, String tagName) {

 }

 }, 
 false//means result instead of formula
 );
 sheetParser.setContentHandler(handler);
 sheetParser.parse(sheetSource);
 } catch (ParserConfigurationException e) {
 throw new RuntimeException("SAX parser appears to be broken - " + e.getMessage());


}
</code></pre>

I Need technology choice to process larger XLS files using Java

<ol>
<li>It needs to process xmls files without out-of-memory exception</li>
<li>It needs to be optimized on memory (working memory) usage</li>
</ol>

pls suggest

Suggestion on API / Framework to Process large XLS files using Java

Java

我需要使用Java处理更大的XLS文件的技术选择它需要处理xmls文件而不会出现内存不足异常它需要在内存(工作内存)使用上进行优化请给我们建议

问使用Java处理大型XLS文件的API / Framework建议
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Java处理大型XLS文件的API / Framework建议EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Java处理大型XLS文件的API / Framework建议
EN