POI 多线程多sheet导出数据

package com.telehot.xzsp.stats.number.service;

import com.google.common.util.concurrent.ThreadFactoryBuilder;
import org.apache.commons.beanutils.PropertyUtilsBean;
import org.apache.commons.lang.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;

import java.beans.PropertyDescriptor;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.concurrent.CountDownLatch;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.LinkedBlockingQueue;
import java.util.concurrent.ThreadFactory;
import java.util.concurrent.ThreadPoolExecutor;
import java.util.concurrent.TimeUnit;

/**
 * 版权：(C) 版权所有 2000-2019 上海天好电子商务股份有限公司苏州分公司
 * <简述>
 * <详细描述> POI 多线程多sheet导出数据
 *
 * @author lichaojie
 * @version V1.0
 * @see
 * @since
 */
public class ThreadExcelUtils {

    /**
     * 定义每个 sheet 最多数量 5w条
     */
    static final Integer EXCEL_MAX_CNT = 50000;

    /**
     * 工作薄
     */
    private HSSFWorkbook wb;

    /**
     * 文件名
     */
    private String fileName;

    /**
     * 路径
     */
    private String filePath;
    /**
     * 标题名称
     */
    private String[] headers;
    /**
     * 字段名称
     */
    private String[] fields;

    public HSSFWorkbook getWb() {
        return wb;
    }

    public String getFileName() {
        return fileName;
    }

    public String getFilePath() {
        return filePath;
    }

    public String[] getFields() {
        return fields;
    }

    /**
     * @param fileName 文件名称
     * @param filePath 文件路径
     * @param headers  文件头
     * @param fields   字段属性
     */
    ThreadExcelUtils(String fileName, String filePath,
                     String[] headers, String[] fields) {
        this.wb = new HSSFWorkbook();
        this.fileName = fileName;
        this.filePath = filePath;
        this.headers = headers;
        this.fields = fields;
    }

    public static void main(String[] args) throws Exception {

        List<Map<String, Object>> lists = new ArrayList<Map<String, Object>>();
        // 造数据
        for (int i = 0; i < 10000; i++) {
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("name1", "张三" + i);
            map.put("name2", "李四" + i);
            map.put("name3", "王五" + i);
            lists.add(map);
        }
        String[] header = {"姓名1", "姓名2", "姓名3"};
        String[] fileNames = {"name1", "name2", "name3"};
        String filePath = "E:\\open";
        String filename = "测试表.xls";
        ThreadExcelUtils utils = new Thr