Java处理数据导出功能

一：思路
前提：首先要获取要导出的数据列表（一般都是通过请求查询条件从数据库中获取数据）；然后调用封装好的生成Excel文件方法，在业务层中渲染文件中的数据列表。
二：步骤
1.导入使用的 jxl.jar ;
在页面定义“导出”按钮，发送导出功能请求；
在控制层中，获取要导出的数据集，传入文件名，执行生成Excel文件方法；

@RequestMapping("/exportChkinm")
@ResponseBody
public boolean exportChkinm(HttpServletResponse response, HttpServletRequest request, HttpSession session, Chkinm chkinm, String checkOrNot, Page page, Date madedEnd) throws Exception{

    //获取数据      
    List<Chkinm> chkinmList = chkinmService.findAllChkinm(checkOrNot, chkinm, page, madedEnd, session.getAttribute("locale").toString());
    //文件名
    String fileName = "已审核入库单汇总";
    //执行方法
    setExpArg(response, request, fileName);
    //返回文件
    return chkinmService.exportRUChkinm(response.getOutputStream(), chkinmList);
}
//生成Excel文件方法
public void setExpArg(HttpServletResponse response,HttpServletRequest request,String fileName) throws UnsupportedEncodingException {
        response.setContentType("application/msexcel; charset=UTF-8");
        if (request.getHeader("User-Agent").toUpperCase().indexOf("MSIE") > 0) {
            //IE
            fileName = URLEncoder.encode(fileName, "UTF-8");
        }else{
            fileName = new String(fileName.getBytes("UTF-8"), "ISO8859-1");
        }
        response.setHeader("Content-disposition", "attachment; filename="+ fileName + ".xls");
}

2.渲染文件数据
在业务层中

public boolean exportRUChkinm(ServletOutputStream outputStream, List<Chkinm> chkinmList) {
    //获取工作薄
    WritableWorkbook workBook = null;
    //设置工作簿样式
    WritableFont titleFont = new WritableFont(WritableFont.TIMES, 16, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
        WritableCellFormat titleStyle = new WritableCellFormat(titleFont);
        try {
            titleStyle.setAlignment(Alignment.CENTRE);
            workBook = Workbook.createWorkbook(outputStream);
            WritableSheet sheet = workBook.createSheet("已审核入库单汇总导出表", 0);
            sheet.addCell(new Label(0, 0, "已审核入库单汇总导出表", titleStyle));
            sheet.mergeCells(0, 0, 11, 0);
            sheet.addCell(new Label(0, 1, "入库单号"));
            sheet.addCell(new Label(1, 1, "凭证号"));
            sheet.addCell(new Label(2, 1, "单据类型"));
            sheet.addCell(new Label(3, 1, "制单日期"));
            sheet.addCell(new Label(4, 1, "制单时间"));
            sheet.addCell(new Label(5, 1, "入库仓位"));
            sheet.addCell(new Label(6, 1, "供应商"));
            sheet.addCell(new Label(7, 1, "总金额"));
            sheet.addCell(new Label(8, 1, "税前总金额"));
            sheet.addCell(new Label(9, 1, "制单人"));
            sheet.addCell(new Label(10, 1, "审核人"));
            //遍历list填充表格内容
            int index = 1;
            for(int j=0; j<chkinmList.size(); j++){
                if(j == chkinmList.size()){
                    break;
                }
                index += 1;
                 sheet.addCell(new Label(0, index, chkinmList.get(j).getChkinno().toString()));
                 sheet.addCell(new Label(1, index, chkinmList.get(j).getVouno()));
                 sheet.addCell(new Label(2, index, chkinmList.get(j).getTyp()));
                 sheet.addCell(new Label(3, index, new SimpleDateFormat("yyyy-MM-dd").format(chkinmList.get(j).getMaded())));
                 sheet.addCell(new Label(4, index, chkinmList.get(j).getMadet()));
                 sheet.addCell(new Label(5, index, String.valueOf(chkinmList.get(j).getPositn().getDes())));
                 sheet.addCell(new Label(6, index, String.valueOf(chkinmList.get(j).getDeliver().getDes())));
                 sheet.addCell(new Label(7, index, Float.toString(chkinmList.get(j).getTotalamt())));
                 sheet.addCell(new Label(8, index, Double.toString(chkinmList.get(j).getNoTaxTotalamt())));
                 sheet.addCell(new Label(9, index, chkinmList.get(j).getMadeby()));
                 sheet.addCell(new Label(10, index,chkinmList.get(j).getChecby()));
            }
            workBook.write();
            outputStream.flush();
        } catch (WriteException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally{
            try {
                if(workBook!=null){
                   workBook.close();
                }
                outputStream.close();
            } catch (WriteException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return true;
    }