POI设置EXCEL单元格格式的操作小结(2)

//第7行

row=sheet.createRow(6);

row.createCell(1).setCellValue(\住户：\ row.createCell(2).setCellValue(\ row.createCell(3).setCellValue(\户)\

cellRangeAddress=new CellRangeAddress(6,6,4,5); sheet.addMergedRegion(cellRangeAddress); row.createCell(4).setCellValue(\共计（ ）\ row.createCell(6).setCellValue(\幢\

cellRangeAddress=new CellRangeAddress(6,6,7,8); sheet.addMergedRegion(cellRangeAddress); row.createCell(7).setCellValue(\发卡张数\

cellRangeAddress=new CellRangeAddress(6,6,9,10); sheet.addMergedRegion(cellRangeAddress); row.createCell(9).setCellValue(\

//第9行

row=sheet.createRow(8);

row.createCell(0).setCellValue(\二、\

cellRangeAddress=new CellRangeAddress(8,8,1,2); sheet.addMergedRegion(cellRangeAddress);

row.createCell(1).setCellValue(\维修用材料台账\ row.createCell(6).setCellValue(\三、\

cellRangeAddress=new CellRangeAddress(8,8,7,9); sheet.addMergedRegion(cellRangeAddress);

row.createCell(7).setCellValue(\维修工时记录\ //第10行

row=sheet.createRow(9);

row.createCell(0).setCellValue(\日期\

row.createCell(1).setCellValue(\维修事项\ row.createCell(2).setCellValue(\材料清单\ row.createCell(3).setCellValue(\数量\ row.createCell(4).setCellValue(\单价\

row.createCell(5).setCellValue(\材料金额\

row.createCell(7).setCellValue(\日期\ row.createCell(8).setCellValue(\技工\ row.createCell(9).setCellValue(\工时数\ row.createCell(10).setCellValue(\单价\ row.createCell(11).setCellValue(\工时金额\

//填充数据

for (int i = 0; i < 10; i++) {

row=sheet.createRow(9+i+1);

row.createCell(0).setCellValue(\日期\

row.createCell(1).setCellValue(\维修事项\ row.createCell(2).setCellValue(\材料清单\ row.createCell(3).setCellValue(\数量\ row.createCell(4).setCellValue(\单价\ row.createCell(5).setCellValue(\材料金额\

row.createCell(7).setCellValue(\日期\ row.createCell(8).setCellValue(\技工\ row.createCell(9).setCellValue(\工时数\ row.createCell(10).setCellValue(\单价\ row.createCell(11).setCellValue(\工时金额\ }

//第n+10行

row=sheet.createRow(9+10+1);

//cellRangeAddress=new CellRangeAddress(19,19,0,4); //sheet.addMergedRegion(cellRangeAddress); row.createCell(0).setCellValue(\累计:\ row.createCell(1).setCellValue(\ row.createCell(7).setCellValue(\累计:\ row.createCell(8).setCellValue(\

// 新建一输出文件流

FileOutputStream fOut = new FileOutputStream(outputFile); // 把相应的Excel 工作簿存盘 workbook.write(fOut); fOut.flush();

// 操作结束，关闭文件 fOut.close();

System.out.println(\文件生成...\

} catch (Exception e) {

System.out.println(\已运行 xlCreate() : \ } } }