数据导出文件生成并下载 java

使用jxl生成xls，将其写入response的outputstream中响应到前端，前端浏览器会自动下载。

  response.reset();

　response.setContentType("application/vnd.ms-excel");

  String filename = “jxlrwtest.xls”；

   response.addHeader("Content-Disposition",
                               "attachment;   filename=\"" + filename + "\"");

　Test.writeExcel(response.getOutputStream());

public static void writeExcel(OutputStream os) throws Exception {
　　jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
　　jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1", 0);
　　jxl.write.Label labelC = new jxl.write.Label(0, 0, "我爱中国");
　　ws.addCell(labelC);
　　jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL,20, WritableFont.BOLD, false,
　　UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN);
　　jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
　　wcfFC.setBackground(jxl.format.Colour.RED);
　　labelC = new jxl.write.Label(6, 0, "中国爱我",wcfFC);
　　ws.addCell(labelC);
　　//写入Exel工作表
　　wwb.write();
　　//关闭Excel工作薄对象
　　wwb.close();
　}