java excel导出详解编程语言

<li class="btns"><input id="btnExport" class="btn btn-primary" 
                type="button" value="导出所有" onclick="exports()" /></li>

function exports(){ 
          top.$.jBox.confirm("确认要导出所有数据吗？","系统提示",function(v,h,f){ 
            if(v=="ok"){ 
            $("#searchForm").attr("action","${ctx}/record/record/record/export"); 
            $("#searchForm").submit(); 
            } 
            },{buttonsFocus:1}); 
            top.$('.jbox-body .jbox-icon').css('top','55px');   
            }

    @RequestMapping(value = "export") 
     public String exportFile(Record record, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) { 
        try { 
            String fileName = "用户数据"+DateUtils.getDate("yyyyMMddHHmmss")+".xlsx"; 
            Page<Record> page = recordService.findRecord(new Page<Record>(request, response, -1), record); 
            new ExportExcel("用户数据", Record.class).setDataList(page.getList()).write(response, fileName).dispose(); 
            return null; 
        } catch (Exception e) { 
            addMessage(redirectAttributes, "导出失败！失败信息："+e.getMessage()); 
        } 
        return "redirect:" + adminPath + "/record/record/record?repage"; 
    } 
    

    public Page<Record> findRecord(Page<Record> page, Record record) { 
        // 生成数据权限过滤条件（dsf为dataScopeFilter的简写，在xml中使用 ${sqlMap.dsf}调用权限SQL） 
        record.getSqlMap().put("dsf", dataScopeFilter(record.getCurrentUser(), "o", "a")); 
        // 设置分页参数 
        record.setPage(page); 
        // 执行分页查询 
        page.setList(recordDao.findList(record)); 
        return page; 
    } 
    

@ExcelField(title="模式", align=2, sort=800, fieldType=RoleListType.class)