JAVA POI通用Excel导入模板

Excel导入模板类

package com.golte.dataform.analysis.controller;

import com.alibaba.fastjson.JSON;
import com.golte.common.GlobalResponse;
import com.golte.dataform.analysis.vo.response.project.ProjectBaseInfoResp;
import com.golte.utils.DateUtils;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.InputStream;
import java.lang.reflect.Field;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Objects;

public class ProjectBasicInfoExcel {
   

    private static String getValue(XSSFCell xssfCell) {
   
        if (Objects.isNull(xssfCell)) {
   
            return null;
        }
        if (xssfCell.getCellType() == CellType.BOOLEAN) {
   
            return String.valueOf(xssfCell.getBooleanCellValue());
        }

        if (xssfCell.getCellType() == CellType.NUMERIC) {
   
            return String.valueOf(xssfCell.getNumericCellValue());
        }

        return String.valueOf(xssfCell);
    }

    @GetMapping("/downTemplate")
    @ApiOperation("下载模板")
    public void