【叨、校长】JAVA WEB 导出Excel报表

 Java代码

1. package com.daodao.servlet;
2.  
3. import java.io.IOException;
4. import java.io.OutputStream;
5.  
6. import javax.servlet.ServletException;
7. import javax.servlet.http.HttpServlet;
8. import javax.servlet.http.HttpServletRequest;
9. import javax.servlet.http.HttpServletResponse;
10.  
11. import org.apache.poi.hssf.usermodel.HSSFCell;
12. import org.apache.poi.hssf.usermodel.HSSFCellStyle;
13. import org.apache.poi.hssf.usermodel.HSSFRow;
14. import org.apache.poi.hssf.usermodel.HSSFSheet;
15. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
16.  
17.  
18. public class TestServlet extends HttpServlet {
19. public void doGet(HttpServletRequest request, HttpServletResponse response)
20. throws ServletException, IOException {
21. String[] header={"第一","第二","第三"};
22. String[][] data={
23. {"A1","A2","A3"},
24. {"B1","B2","B3"},
25. {"C1","C2","C3"}
26. };
27. HSSFWorkbook wb = new HSSFWorkbook();
28. HSSFSheet sheet = wb.createSheet("测试");
29. HSSFRow row = sheet.createRow((int) 0);
30. HSSFCellStyle style = wb.createCellStyle();
31. for (int i = 0; i < header.length; i++) {
32. HSSFCell cell = row.createCell((short) i);
33. cell.setCellValue(header[i]);
34. sheet.autoSizeColumn((short) i);
35. }
36.  
37. for (int i = 0; i < data.length; i++) {
38. row = sheet.createRow(i + 1);
39. row.createCell((short) 0).setCellValue(data[i][0]);
40. row.createCell((short) 1).setCellValue(data[i][1]);
41. row.createCell((short) 2).setCellValue(data[i][2]);
42. }
43. response.setContentType("application/vnd.ms-excel");
44. response.setHeader("Content-disposition", "p_w_upload;filename=test.xls");
45. OutputStream ouputStream = response.getOutputStream();
46. wb.write(ouputStream);
47.  
48. }
49. }