java 使用POI导出复杂excel表格，通过浏览器下载

pom.xml依赖

<!--POI Excel表格导出依赖-->
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>3.17</version>
</dependency>

具体实现根据自己需求修改，代码：

import com.open.capacity.common.code.C00;
import com.open.capacity.common.envm.cate.ProjExeConditionCate;
import com.open.capacity.common.envm.recid.DictId;
import com.open.capacity.common.exception.controller.ControllerException;
import com.open.capacity.common.exception.service.ServiceException;
import com.open.capacity.common.util.SysUserUtil;
import com.open.capacity.common.web.Result;
import com.open.capacity.project.dao.ProjExeConditionDao;
import com.open.capacity.project.dao.ProjSummaryDao;
import com.open.capacity.project.dao.ProjUserInfoDao;
import com.open.capacity.project.entity.ProjExeCondition;
import com.open.capacity.project.entity.ProjExeConditionDTO;
import com.open.capacity.project.entity.ProjtSitra;
import com.open.capacity.project.feign.ProjUserFeignClient;
import com.open.capacity.project.service.ProjExeConditionService;
import com.open.capacity.project.util.PageResultUtil;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.open.capacity.common.web.PageResult;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;

import java.io.IOException;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.math.BigDecimal;
import java.net.URLEncoder;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.commons.collections4.MapUtils;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


@Service
public class ProjExeConditionServiceImpl  implements ProjExeConditionService {

    /**
     * 导出项目执行情况（月度执行情况、季度执行情况） - 统计报表（excel）
     *
     * @param params   查询条件
     * @param request  request
     * @param response response
     * @return :
     * @author : hjk
     */
    @Override
    public Result listStaticImportExcel(Map<String, Object> params, HttpServletRequest request, HttpServletResponse response) {
        try {
            //其他查询逻辑
            //
            ProjExeConditionDTO projExeConditionDTO = new ProjExeConditionDTO();
            if (MapUtils.getInteger(params, "projDataId") != null && MapUtils.getInteger(params, "projDataId") != null) {
                projExeConditionDTO = projExeConditionDao.getProjInfo(MapUtils.getInteger(params, "projDataId"));
            } else {
                projExeConditionDTO.setProjUnit(MapUtils.getString(params, "projUnit"));
            }
            projExeConditionDTO.setFillTime(MapUtils.getString(params, "startTime"));
            //分页查询 === BEGIN === 设置分页信息，分别是当前页数和每页显示的总记录数【记住：必须在mapper接口中的方法执行之前设置该分页信息，中间不能有其他查询执行】
            if (