Java POI导出excel

话不多说直接上代码,如果适合你,麻烦给个赞!!!
package com.dajie.notice.util;

import java.io.IOException;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import javax.servlet.http.HttpServletResponse;

import com.dajie.notice.controller.me.MeExportController;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.RichTextString;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFRichTextString;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * 多功能excel导出
 *
 * @author kangzhuang
 * @ClassName: PoiExportExcel.java
 * @Description:
 */
public class PoiExportComplexExcel {
    /**
     * 日志
     */
    private static final Logger logger = LoggerFactory.getLogger(MeExportController.class);
    //导出表名
    private String fileName;
    //显示的导出表的标题
    private String title;
    //导出表的列名
    private String[] rowName;
    //定义导出数据集合
    private List<Object[]> dataList = new ArrayList<Object[]>();
    HttpServletResponse response;

    //构造方法，传入要导出的数据
    public PoiExportComplexExcel(String fileName, String title, String[] rowName,
                                 List<Object[]> dataList, HttpServletResponse response) {
        this.fileName = fileName;
        this.title = title;
        if (rowName == null) {
            this.rowName = new String[0];
        } else {
            this.rowName = Arrays.copyOf(rowName, rowName.length);
        }
        this.dataList = dataList;
        this.response = response;
    }

    /**
     * 创建excel
     *
     * @pa