读取大型Excel文件.xlsx [英] Read large Excel file .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 appreciated ThankQ 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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！