jxl 导出excel

本文记录下用jxl.jar进行数据导出至excel的操作，在这博主特别提示一点，请求后台导出数据时使用form表单提交，不要用ajax！不要用ajax！不要用ajax！否则各种莫名其妙的error自己去收拾吧～

废话不多说了，小二，上代码！

java

@RequestMapping(value = "queryPostOrderForExcel", produces = "text/html; charset=UTF-8")
@ResponseBody

public void queryPostOrderForExcel(String startDate, String endDate, HttpServletRequest request, HttpServletResponse response)
    {
        // 查询数据
        List<ExportPostOrderBean> list = orderService.queryPostOrderForExcel(startDate, endDate);
        // 将数据导出
        Date now = new Date();
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");
        String curDate = dateFormat.format(now);
        try
        {
            ByteArrayOutputStream OutExcel = new ByteArrayOutputStream();
            WritableWorkbook book = Workbook.createWorkbook(OutExcel);
            WritableSheet sheet = book.createSheet("信息表", 0);
            sheet.setRowView(0, 600);
            Label lab = null;
            lab = new Label(3, 0, "姓名");
            sheet.addCell(lab);
            lab = new Label(4, 0, "号码");
            sheet.addCell(lab);
            lab = new Label(5, 0, "地址");
            sheet.addCell(lab);

            for (int i = 0; i < list.size(); i++)
            {
                //查询出来需要导出的数据源
                ExportPostOrderBean postOrder = list.get(i);

                String[] strList = new String[5];
                strList[0] = postOrder.getUserName();
                strList[1] = postOrder.getTelPhone();
                strList[2] = address;

                for (int j = 0; j < strList.length; j++)
                {
                    lab = new Label(j, (i + 1), strList[j]); // Label(col,row,str);
                    sheet.addCell(lab);
                }
            }
            book.write();
            book.close();
            String ExcelFileName = "信息表" + curDate + ".xls";
            response.setCharacterEncoding("UTF-8");
            response.setContentType("application/x-msdownload");
            response.setContentLength(OutExcel.size());
            response.addHeader("Content-Disposition", "attachment; filename=" + ExcelFileName);
            ServletOutputStream out = response.getOutputStream();
            OutExcel.writeTo(out);
            OutExcel.flush();
        }
        catch (Exception e)
        {
            e.printStackTrace();
            logger.error("导出信息表异常。");
        }

    }
}

实现效果如图：

1、确定需要导出数据的条件

2、点击确认进行数据查询并导出操作