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

专针对导出excel2007 ，用到poi3.9的jarpackage com.cares.ynt.util;import java.io.File;import java.io.FileOutputStream;import java.io.IOException;import java.io.OutputStream;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.List;import org.apache.poi.ss.usermodel.CellStyle;import org.apache.poi.ss.usermodel.Font;import org.apache.poi.ss.usermodel.IndexedColors;import org.apache.poi.xssf.streaming.SXSSFCell;import org.apache.poi.xssf.streaming.SXSSFRow;import org.apache.poi.xssf.streaming.SXSSFSheet;import org.apache.poi.xssf.streaming.SXSSFWorkbook;import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataFormat;import org.apache.poi.xssf.usermodel.XSSFFont;public class ExportData {private XSSFCellStyle head_Style;private SXSSFWorkbook workbook;// 当前sheetprivate SXSSFSheet sheet;private SXSSFRow row = null;// 创建一行private SXSSFCell cell = null;private String headers[][];private int currentRow = 0;private XSSFCellStyle date_Style ;private XSSFCellStyle time_Style ;private XSSFCellStyle string_style;private SimpleDateFormat sdf = new SimpleDateFormat(yyyy/MM/dd HH:mm:ss);/** * 构造函数初始化参数 * @param out * @param title * @param headers * @param sheeatName */public ExportData(String title,String[][] headers,String sheeatName){this.headers = headers;try{workbook=new SXSSFWorkbook();this.head_Style=(XSSFCellStyle) this.workbook.createCellStyle();head_Style.setBorderBottom(XSSFCellStyle.BORDER_THIN);head_Style.setBorderLeft(XSSFCellStyle.BORDER_THIN);head_Style.setBorderRight(XSSFCellStyle.BORDER_THIN);head_Style.setBorderTop(XSSFCellStyle.BORDER_THIN);head_Style.setFillForegroundColor(IndexedColors.AQUA.getIndex());head_Style.setFillPattern(CellStyle.SOLID_FOREGROUND);head_Style.setAlignment(XSSFCellStyle.ALIGN_CENTER);XSSFFont head_font = (XSSFFont) workbook.createFont();head_font.setFontName(宋体);// 设置头部字体为宋体head_font.setBol