public void initPOI() { String str=""; String file="F:/test1/527/a2.xls"; try { FileInputStream fis=new FileInputStream(file); POIFSFileSystem poif=new POIFSFileSystem(fis); FileOutputStream out = new FileOutputStream(file); HSSFWorkbook book=new HSSFWorkbook(poif); HSSFSheet sheet=book.createSheet("feng1"); sheet.addMergedRegion(new CellRangeAddress(0,1,0,0)); sheet.addMergedRegion(new CellRangeAddress(0,0,1,2)); sheet.addMergedRegion(new CellRangeAddress(0,0,3,4)); Row titlerow=sheet.createRow(0); titlerow.createCell(0).setCellValue("统计"); titlerow.createCell(1).setCellValue("商务部"); titlerow.createCell(3).setCellValue("财政部"); Row row=sheet.createRow(1); row.createCell(0).setCellValue(""); row.createCell(1).setCellValue("日累计"); row.createCell(2).setCellValue("月累计"); row.createCell(3).setCellValue("日累计"); row.createCell(4).setCellValue("月纪累计"); fis.close(); book.write(out); out.flush(); out.close(); } catch (Exception e) { e.printStackTrace(); } }