导出excel工具类和依赖

依赖

      <dependency>
          <groupId>org.apache.poi</groupId>
          <artifactId>poi</artifactId>
          <version>4.0.1</version>
      </dependency>

      <!--支持07年之前的-->
      <dependency>
          <groupId>org.apache.poi</groupId>
          <artifactId>poi-ooxml</artifactId>
          <version>4.0.1</version>
      </dependency>

工具类

package com.xy.xuld.utils;

import com.xy.xuld.modules.vo.ExcelData;
import org.apache.commons.compress.utils.IOUtils;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFColor;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Value;

import javax.servlet.http.HttpServletResponse;
import java.io.BufferedInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLConnection;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

/**
 * Created by Dell on 2019/5/10.
 */
public class ExcelUtils {
   

    private static Logger logger= LoggerFactory.getLogger(ExcelUtils.class);

    public static void exportExcel(ExcelData data, HttpServletResponse response) throws Exception {
   
        XSSFWorkbook wb = new XSSFWorkbook();
        try {
   
            String sheetName = data.getName();
            if (null == sheetName) {
   
                sheetName = "Sheet1";
            }
            XSSFSheet sheet = wb.createSheet(sheetName);
            writeExcel(wb, sheet, data);
            String fileName=data.getName()+"("+DateUtil.convertDate2String("yyyyMMddHHmmssSSS",new Date())+")"