poi大数据导出20万没内存溢出过

《poi大数据导出20万没内存溢出过》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、专针对导出excel2007,用到poi3.9的jarpackagecom.cares.ynt.util;importjava.io.File;importjava.io.FileOutputStream;importjava.io」OException;importjava.io.Outputstream;importjava.text.ParseException;importjava.text.SimpleDateFormat;importjava.util.ArrayUst;importjava.util.

2、Date;importjava.util.List;importorg.apache.poi.ss.usermodel.CellStyle;importorg.apache.poi.ss.usermodel.Font;importorg.apache.poi.ss.usermodel.IndexedColors;importorg.apache.poi.xssf.streaming.SXSSFCell;importorg.apache.poi.xssf.streaming.SXSSFRow;importorg.ap

3、ache.poi.xssf.streaming.SXSSFSheet;importorg.apache.poi.xssf.streaming.SXSSFWorkbook;importorg.apache.poi.xssf.usermodel.XSSFCell;importorg.apache.poi.xssf.usermodel.XSSFCellStyle;importorg.apache.poi.xssf.usermodel.XSSFDataFormat;importorg.apache.poi.xssf.use

4、rmodel.XSSFFont;publicclassExportData{privateXSSFCellStylehead_Style;privateSXSSFWorkbookworkbook;〃当前sheetprivateSXSSFSheetsheet;privateSXSSFRowrow=null;//创建一行privateSXSSFCellcell=null;privateStringheaders!][];privateintcurrentRow=0;privateXSSFCellStyledate_St

5、yle;privateXSSFCellStyletime_Style;privateXSSFCellStylestring_style;privateSimpleDateFormatsdf=newSimpleDateFormat(,,yyyy/MM/ddHH:mm:ssH)；/***构造函数初始化参数*@paramout*@paramtitle*@paramheaders*@paramsheeatName*/publicExportData(Stringtitle,String[][]headers,Strings

6、heeatName){this.headers=headers;try{workbook=newSXSSFWorkbook();this.head_Style=(XSSFCellStyle)this.workbook.createCellStyle();head_Style.setBorderBottom(XSSFCellStyle.BORDER_THIN);head_Style.setBorderLeft(XSSFCellStyle.BORDER_THIN);head_Style.setBorderRight(X

7、SSFCellStyle.BORDER_THIN);head_Style.setBorderTop(XSSFCellStyle.BORDER_THIN);head_Style.setFillForegroundColor(lndexedColors.AQUA.getlndex());head_Style.setFillPattern(CellStyle.SOLID_FOREGROUND);head_Style.setAlignment(XSSFCellStyle.ALIGN_CENTER);XSSFFonthead

8、_font=(XSSFFont)workbook.createFont();head_font.setFontName("宋体”);〃设置头部字体为宋体head_font.setBoldweight(Font.BOLDWEIGHT_BOLD);//粗体head_font.setFontHeightlnPoints((short)11);this.headSt