/**

 *    处理Excel的util

 */

 public class ExcelUtil{

     public static void fillExcelData(ResultSet rs, Workbook wb, String[] headers) throws Exception{

         int rowIndex = 0;

         Sheet sheet = wb.createSheet();

         Row row = sheet.createRow(rowIndex++);

         for(int i=0; i<headers.length; i++){

             row.createCell(i).setCellValue(headers[i]);

         }

         //这里假设的是头的列数和数据的列数是一样的

         while(rs.next()){

             row = sheet.createRow(rowIndex++);

             for(int i=0; i<headers.length; i++){

                 row.createCell(i).setCellValue(rs.getObject(i+1).toString());

             }

         }

     }

 }

 /**

 *    ResponseUtil相应util

 */

 public class ResponseUtil{

     public static void write(HttpServletResponse response, Object o) throws Exception{

         response.setContentType("text/html;charset=utf-8");

         PrintWriter pw = response.getWriter();

         pw.print(o.toString());

         pw.flush();

         pw.close();

     }

     /**

     *导出Excel

     * fileName: 导出的文件名

     */

     public static void export(HttpServletResponse response, Workbook wb, String fileName) throws Exception{

         response.setHeader("Content-Disposition", "attachment;filename="

             +new String(fileName.getBytes("utf-8"), "iso8859-1"));

         response.setContentType("application/ynd.ms-excel;charset=UTF-8");

         OutputStream out = response.getOutputStream();

         wb.write(out);

         out.flush();

         out.close();

     }

 }