java poi 导出excel 速度慢_java POI技术之导出数据优化（15万条数据1分多钟）

专针对导出excel2007 ，用到poi3.9的jar

package 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;

// 当前sheet

private 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/d