使用SXSSFWorkbook来导出excel

向右看齐 2021-09-20 01:46 812阅读 0赞

[为什么80%的码农都做不了架构师？>>> ][80_]  ![hot3.png][]

## 序 ##

SXSSFWorkbook是XSSFWorkbook的Streaming版本，实现了"BigGridDemo"的策略，在导出大量数据的时候，可以避免OOM。

## 使用实例 ##

@Test
        public void testWriteLargeData() throws IOException {
            FileInputStream inputStream = new FileInputStream("mytemplate.xlsx");
            XSSFWorkbook wb_template = new XSSFWorkbook(inputStream);
            inputStream.close();
    
            SXSSFWorkbook wb = new SXSSFWorkbook(wb_template);
            wb.setCompressTempFiles(true);
    
            SXSSFSheet sh = (SXSSFSheet) wb.getSheetAt(0);
            sh.setRandomAccessWindowSize(100);// keep 100 rows in memory, exceeding rows will be flushed to disk
            for(int rownum = 4; rownum < 100000; rownum++){
                Row row = sh.createRow(rownum);
                for(int cellnum = 0; cellnum < 10; cellnum++){
                    Cell cell = row.createCell(cellnum);
                    String address = new CellReference(cell).formatAsString();
                    cell.setCellValue(address);
                }
    
            }
    
    
            FileOutputStream out = new FileOutputStream("tempsxssf.xlsx");
            wb.write(out);
            out.close();
            // dispose of temporary files backing this workbook on disk
            wb.dispose();
        }

## doc ##

*  [BigGridDemo][]

转载于:https://my.oschina.net/go4it/blog/1499079

[80_]: https://my.oschina.net/u/2663968/blog/3051541
[hot3.png]: /images/20210726/be97c9685175410daa6f799588c2b870.png
[BigGridDemo]: https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java