Excel 导出

 

Excel 导出功能：

 

Workbook workBook = ........; String excelName = “”; response.setContentType("application/vnd.ms-excel;charset=GBK"); response.setHeader("Content-Disposition", "attachment;filename=" + excelName); ByteArrayOutputStream outputStream = null; try { outputStream = new ByteArrayOutputStream(); workBook.write(outputStream); byte[] b = outputStream.toByteArray(); rundata.getResponse().getOutputStream().write(b); } catch (IOException e) { try { outputStream.close(); } catch (IOException e1) { } } finally { try { outputStream.close(); } catch (IOException e1) { } } 

 

Poi Excel　具体使用方法：

http://poi.apache.org/spreadsheet/index.html