使用jxl导出excel

一.首先创建响应头

    response.reset();
    response.setContentType("application/x-download;charset=utf-8");
    String fileName = "客户经营书" + new SimpleDateFormat("yyyyMMddHHmmss").format(new Date());
    response.setHeader("Content-Disposition","attachment;filename=" + URLEncoder.encode(fileName, "UTF-8") + ".xls");

二.使用jxl操作excel

    WritableWorkbook wwb=null;  //创建WritableWorkbook 对象
    ServletOutputStream outputStream =   response.getOutputStream(); //获取一个输出字符流
    try {
        String[] title = {"", "", "", "", "", "", "","","",""}; //excel标题
        wwb = Workbook.createWorkbook(outputStream);
        // 添加第一个工作表并设置第一个Sheet的名字
        WritableSheet sheet = wwb.createSheet("客户经营书", 0);
        Label label;
        for (int i = 0; i < title.length; i++) {
            label = new Label(i, 0, title[i]);
            // 将定义好的单元格添加到工作表中
            sheet.addCell(label);
        }
        /*
         * 保存数字到单元格，需要使用jxl.write.Number
         * 必须使用其完整路径，否则会出现错误
         * */
        label = new Label(0,  1, "本月档位");
        sheet.addCell(label);
        label = new Label(1,  1, jj.getByGear());
        sheet.addCell(label);
        label = new Label(2,  1, "本月星级");
        sheet.addCell(label);
     
        label = new Label(0,  2, "本月购进量");
        sheet.addCell(label);
        label = new Label(1,  2, jj.getByBuyVolume());
        sheet.addCell(label);
        label = new Label(2,  2, "同比增减");
        sheet.addCell(label)
        wwb.write();  //将内容写入

    } catch (Exception e){
        e.printStackTrace();
    }finally {
        try{
            // 关闭文件
            wwb.close();
        }catch (Exception e){
            e.printStackTrace();
        }
    }