jsp导出Excel 样式配置.doc

jsp导出excel之格式控制 2009-08-26 14:43:29| 分类： Java扩展 | 标签： |字号大中小 订阅 + size); HSSFCell data_cell0 = null; HSSFCell data_cell1 = null; HSSFCell data_cell2 = null; HSSFCell data_cell3 = null; HSSFCell data_cell4 = null; HSSFCell data_cell5 = null; HSSFCell data_cell6 = null; HSSFCell data_cell7 = null; for (int i = 0; i 10) tempDate= tempDate.replaceAll( 00:00:00,); tempDate = tempDate.replaceAll(.,-); data_cell3.setCellValue(tempDate); /标题 data_cell4 = row.createCell(short) 4); data_cell4.setEncoding(HSSFCell.ENCODING_UTF_16); data_cell4.setCellStyle(cs3); data_cell4.setCellValue(rs.getString(fldSubject); /拟稿部门 data_cell5 = row.createCell(short) 5); data_cell5.setEncoding(HSSFCell.ENCODING_UTF_16); data_cell5.setCellStyle(cs3); data_cell5.setCellValue(rs.getString(fd_planDept); /拟稿人 data_cell6 = row.createCell(short) 6); data_cell6.setEncoding(HSSFCell.ENCODING_UTF_16); data_cell6.setCellStyle(cs3); data_cell6.setCellValue(rs.getString(seJbMan); /备注 data_cell7 = row.createCell(short) 7); data_cell7.setEncoding(HSSFCell.ENCODING_UTF_16); data_cell7.setCellStyle(cs3); data_cell7.setCellValue(rs.getString(Fd_Remark); /response.setCharacterEncoding(gbk); response.setContentType(application/octet-stream); response.setHeader(Content-Disposition, attachment;filename=_Report.xls); workbook.write(response.getOutputStream(); response.getOutputStream().flush(); respo