excel导出数据很多，拆分成多个，以Excel的方式导出

package com.komlin.modular.work.controller;

import com.komlin.component.consts.FilePathConsts;
import com.komlin.component.model.ResponseBase;
import com.komlin.component.page.Pager;
import com.komlin.component.utils.QrCodeUtils;
import com.komlin.component.utils.UUIDUtils;
import com.komlin.modular.draw.model.service.DrawQrcodeService;
import com.komlin.modular.draw.model.service.LuckyDrawService;
import com.komlin.modular.product.model.service.ProductBatchService;
import com.komlin.modular.product.model.service.ProductInfoService;
import com.komlin.modular.product.model.service.UnitCodeService;
import com.komlin.modular.work.bo.TraceQrcodeBo;
import com.komlin.modular.work.model.entity.TbTraceQrcode;
import com.komlin.modular.work.model.service.GenerateRecordService;
import com.komlin.modular.work.model.service.TraceQrcodeService;
import com.komlin.modular.work.model.service.WorkFlowService;
import com.komlin.modular.work.model.service.WorkTraceMappingService;
import org.apache.commons.io.FileUtils;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Row;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * Created by zql on 2017/12/11.
 */
@Controller
@RequestMapping("works")
public class ExportController {
    @Autowired
    private TraceQrcodeService qrcodeService;
    @Autowired
    private ProductBatchService batchService;
    @Autowired
    private DrawQrcodeService drawQrcodeService;
    @Autowired
    private LuckyDrawService luckyDrawService;
    @Autowired
    private WorkFlowService workFlowService;
    @Autowired
    private WorkTraceMappingService workTraceMappingService;
    @Autowired
    private UnitCodeService unitCodeService;

    @Autowired
    private ProductInfoService productInfoService;

    @Autowired
    private GenerateRecordService generateRecordService;

   /* @ResponseBody
    @RequestMapping("exportCollectQrocde")
    public ResponseBase exportCollectQrocde(TraceQrcodeBo bo) {
        ResponseBase result;
        int MAX_PAGER = 500;
        try {
            if (bo == null) {
                bo = new TraceQrcodeBo();
            }
            bo.pagesize = 5000;
            File model = new File(FilePathConsts.rootPath
                    + "file/excel/export_collect_qrcode.xls");
            FileInputStream fis &#