s-HR导出excel方式二

js代码：

exportToExcelAction:function(){
        var billId = _self.getCurrentModelID();
        billId = encodeURIComponent(billId);
        var url = shr.getContextPath() + "/dynamic.do?handler=com.kingdee.eas.custom.dfxw.pssf.handler.AFOwnBaseAdjustEditHandler&method=exportToExcel&billId=" + billId;
        var sbjndw = $("#sbjndw").text();
        var rq = new Date().format("yyyyMMdd");
        this.download(url, sbjndw+"公积金个人基数调整"+rq+".xls");
    },
    /*文件字节流下载*/
    download: function (url, fileName) {
        var xhr = new XMLHttpRequest();
        xhr.open('post', url, true); // 也可以使用POST方式，根据接口
        xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
        xhr.responseType = "blob"; // 返回类型blob
        // 定义请求完成的处理函数，请求前也可以增加加载框/禁用下载按钮逻辑
        xhr.onload = function () {
            // 请求完成
            if (this.status === 200) {
                // 返回200
                var blob = this.response;
                
                var reader = new FileReader();
                if(this.response.type == 'application/json'){
                    reader.readAsText(blob); // 转换为base64，可以直接放入a表情href
                    reader.onload = function (e) {
                        var data = JSON.parse(e.target.result);
                        var result = data.result;
                        var a = JSON.parse(data.data);
                        if(result == "success"){
                            shr.showError({
                                            message: JSON.stringify(a.errmsg)
                                        });
                        }
                    }
                }else{
                    const ie = navigator.userAgent.match(/MSIE\s([\d.]+)/),
                    ie11 = navigator.userAgent.match(/Trident\/7.0/) && navigator.userAgent.match(/rv:11/),
                    ieEDGE = navigator.userAgent.match(/Edge/g),
                    ieVer = (ie ? ie[1] : (ie11 ? 11 : (ieEDGE ? 12 : -1)));
                console.log('ie:' + ie);
                console.log('ieVer:' + ieVer);
                if (ieVer > -1) {
                    window.navigator.msSaveBlob(blob, fileName);
                }else{
                    reader.readAsDataURL(blob); // 转换为base64，可以直接放入a表情href
                    reader.onload = function (e) {
                        // 转换完成，创建一个a标签用于下载
                        var a = document.createElement('a');
                        a.download = fileName;
                        a.href = e.target.result;
                        $("body").append(a); // 修复firefox中无法触发click
                        a.click();
                        $(a).remove();
                    }
                }
                    
                }
                
            }
        };
        // 发送ajax请求
        xhr.send(null);
    },

 

handler代码：

public void exportToExcelAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap)
      throws SHRWebException{
        System.out.println("exportToExcel");
        Context ctx = SHRContext.getInstance().getContext();
        String id = request.getParameter("billId");
        
        String[] head = {"序号","员工","公积金缴纳单位","编码","工资","入集团时间","原公积金规则-原基数规则名称","原公积金规则-原基数种类名称","原公积金规则-原基数","现申请公积金规则-拟调基数","申请原因","生效期间"};
        
        String[] fields = {"seq","person","ncUnit","personnumber","salary","joinDate","oldBaseName","oldBaseType","oldBase","newBase","description","usePeriod"};
        StringBuffer sql = new StringBuffer();

        sql.append("/*dialect*/select entry.fseq seq,zy.fname_l2 person,nc.fname_l2 ncUnit,zy.fnumber personnumber,cfsalary salary,to_char(cfjoinDate,'yyyy-MM-dd') joinDate, ");
        sql.append("brule.fname_l2 oldBaseName,case when cfoldBaseType=1 then '固定' when cfoldBaseType=2 then '分档' when cfoldBaseType=2 then '去年平均工资' else '上月应发工资' end oldBaseType, ");
        sql.append("cfoldBase oldBase,cfnewBase newBase,entry.fdescription description,to_char(cfusePeriod,'yyyy-MM-dd') usePeriod ");
        sql.append("from CT_PSS_AFOwnBaseAdjustentry entry ");
        sql.append("left join CT_BD_NCywdyjczl nc on entry.cfncunitid=nc.fid  ");
        sql.append("left join CT_PSS_FundBaseRule brule on entry.cfoldbasenameid=brule.fid ");
        sql.append("left join T_BD_Person zy on entry.fpersonid=zy.fid  ");
        sql.append("where fbillid ='"+id+"' order by entry.fseq ");
        
        //遍历数据，生成一张分录excel
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFCellStyle cellStyle = wb.createCellStyle();
        DataFormat format = wb.createDataFormat();
        cellStyle.setDataFormat(format.getFormat("#,##0.00"));//金额字段格式
        HSSFSheet sheet = wb.createSheet("数据表");
        Row row = null;
        Cell cell = null;
        row = sheet.createRow(0);
        for(int i=0;i<head.length;i++){
            cell = row.createCell(i);
            cell.setCellValue(head[i]);
        }
        int rowIndex = 1;
        try {
            IRowSet rs = DbUtil.executeQuery(ctx, sql.toString());
            while (rs.next()) {
                Row tempRow = sheet.createRow(rowIndex);
                for(int i=0;i<fields.length;i++){
                    Cell tempCell = tempRow.createCell(i);
                    if(i==0){
                        tempCell.setCellValue(rs.getInt(fields[i]));
                    }else if((i==4 || i==8 && i==9)){
                        tempCell.setCellStyle(cellStyle);
                        tempCell.setCellValue(rs.getDouble(fields[i]));
                    }else{
                        tempCell.setCellValue(rs.getString(fields[i]));
                    }
                }
                rowIndex++;

            }
            String fileName = "数据表.xls";
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-Disposition", "attachment;filename=\"" + fileName+"\"");
            OutputStream out = response.getOutputStream();
            wb.write(out);
            out.flush();
            out.close();
        } catch (BOSException e) {
            System.out.println(e.getMessage());
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } catch (IOException e) {
            System.out.println(e.getMessage());
        }
    }