使用SXSSFWorkbook处理大量导出数据

   Controller：

@PostMapping("/exportOrtDetail")
    public void exportOrtDetail(HttpServletRequest request, HttpServletResponse response){
        JsonUtil jsonUtil = new JsonUtil();
        SwitchDbInfo dbInfo;
        OrtDetail ortDetail;
        try {
            JSONObject obj = jsonUtil.getJsonObject(request);
            dbInfo = obj.getObject("dbInfo", SwitchDbInfo.class);
            ortDetail = obj.getObject("data", OrtDetail.class);
            service.exportOrtDetail(ortDetail,response,dbInfo);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

Service：

void exportOrtDetail(OrtDetail ortDetail,HttpServletResponse response,SwitchDbInfo dbInfo) throws IOException;

Impl：

    @Override
    public void exportOrtDetail(OrtDetail ortDetail, HttpServletResponse response,SwitchDbInfo dbInfo) throws IOException {
        ResponseData responseData=ortReport(dbInfo,ortDetail);
        List<OrtDetail> details=(List<OrtDetail>) responseData.getData();
        //將對象轉換成Map
        List<Map<String,String>> mapList=objToMap(details);
        //創建表頭
        List<String> tableHeader=getTableHe