如何用Java编写程序实现Excel文件的编辑与处理？

本文共计472个文字，预计阅读时间需要2分钟。

javapublic void createExcel() { String sheetName=新建自助案件及线索报送考评表; String[] cellName={单元, 总数, 学科平均}; HSSFWorkbook workbook=new HSSFWorkbook(); // ... (后续操作)}

java实现excel

public void createExcel(){ String SheetName = "新立自办案件及线索报送考评表 "; String[] cellName; cellName = new String[] { "单位" , " 总数", "科级干部 "}; HSSFWorkbook workbook = new HSSFWorkbook(); /******************* 样式定义开始 *******************/ HSSFCellStyle style = workbook.createCellStyle(); HSSFCellStyle style2 = workbook.createCellStyle(); // style.setBorderTop(HSSFCellStyle.BORDER_THIN); // 字体设置 HSSFFont font = workbook.createFont(); font.setFontName( "宋体" );// 设置字体 // font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);// 粗体显示 font.setFontHeightInPoints(( short) 11); // 设置字体大小 font.setBoldweight(HSSFFont. BOLDWEIGHT_BOLD); // 设置字体加粗 style.setFont(font); style.setAlignment(HSSFCellStyle. ALIGN_CENTER); // 设置文本居中 style2.setAlignment(HSSFCellStyle. ALIGN_CENTER); // 设置文本居中 /******************* 样式定义结束 *******************/ // 设置模板sheet HSSFSheet sheet1 = workbook.createSheet(); // 设置模板名称，防止中文乱码，重要 // workbook.setSheetName(0, SheetName); // 添加标题行 HSSFRow row_title = sheet1.createRow(( short) 0); // 添加标题行所属的列 for ( int i = 0; i < cellName. length; i++) { HSSFCell cell = row_title.createCell(( short) i); cell.setCellType(HSSFCell. CELL_TYPE_STRING); // 设置编码格式，防止中文乱码，重要 cell.setEncoding(HSSFCell. ENCODING_UTF_16); cell.setCellValue(cellName[i]); // 设置列宽度,1 个字符700宽度 (一个中文的长度，同字体大小相关 ) int length = (cellName[i].length() * 1000); if (i == 5) { length = 12000; } sheet1.setColumnWidth(( short) i, ( short) length); // 设置文本样式 cell.setCellStyle(style); } //页面条件查询 String endYf = getRequest().getParameter( "endYf"); String startYf = getRequest().getParameter("startYf" ); String nf = getRequest().getParameter( "nf"); Map map = jxkpService.queryJxkp(nf, startYf,endYf); for ( int i = 0; i < map.size(); i++) { HSSFRow row = sheet1.createRow(( short) (i + 1));// 生成一行 JxkpHz bean = map.get(i); HSSFCell cell = row.createCell(( short) 0); cell.setCellType(HSSFCell. CELL_TYPE_STRING); cell.setEncoding(HSSFCell. ENCODING_UTF_16); cell.setCellValue(bean.getDq()); cell.setCellStyle(style2); HSSFCell cell1 = row.createCell(( short) 1); cell1.setCellType(HSSFCell. CELL_TYPE_STRING); cell1.setEncoding(HSSFCell. ENCODING_UTF_16); cell1.setCellValue(bean.getZbajzs()); cell1.setCellStyle(style2); HSSFCell cell2 = row.createCell(( short) 2); cell2.setCellType(HSSFCell. CELL_TYPE_STRING); cell2.setEncoding(HSSFCell. ENCODING_UTF_16); cell2.setCellValue(bean.getZbajkj()); cell2.setCellStyle(style2); } response.reset(); response.setContentType( "application/vnd.ms-excel" ); try { response. setHeader( "Content-Disposition" , "attachment;filename=" + URLEncoder.encode(SheetName.toString() + ".xls" , "UTF8" )); workbook.write(response.getOutputStream()); response.getOutputStream().flush(); response.getOutputStream().close(); } catch (UnsupportedEncodingException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } }