本文介绍了读取大型Excel文件.xlsx的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用图书馆
org.apache.poi
XSSFWorkbook workbook = new XSSFWorkbook(fileInputStream);
我正在尝试
org.xml.sax
库,但无法将其转换为工作簿
library, but cannot able convert it into workbook
注意:最终结果是我希望返回XSSFWorkbook
NOTE : at end result i want XSSFWorkbook to be returned
上面的代码将耗尽内存,任何帮助将不胜感激提前感谢Q
the above code will go out of memory, any help will be appreciatedThankQ in advance
推荐答案
InputStream is = new FileInputStream(new File("yourXLSX file path"));
Workbook workbook = StreamingReader.builder().rowCacheSize(100).bufferSize(4096).open(is))
for (Sheet sheet: workbook) {
//System.out.println(sheet.getSheetName());
for (Row r: sheet) {
for (Cell c: r) {
//System.out.println(c.getStringCellValue());
}
}
}
这篇关于读取大型Excel文件.xlsx的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!