poi 修改现有excel样式

「已注销」 2013-01-25 04:35:07

问题描述:1.现有一excel,现在给这个excel插入数据并定义单元格格式,但格式定义总是无效,貌似我的用法有问题,但又没找到原因...
2.如果复制某一个单元格的格式
3.如何自动撑高
代码如下:



	public String createExcelByModelAndDatas(String excelModel, String excelTop, String[][] excelData, int startrow, int startcol, int endcol) throws Exception {

		// 首先复制一份文件

		File newfile = copyFile(excelModel,excelTop);

		// 然后把数据插进去

		FileInputStream fis = new FileInputStream(newfile.getAbsolutePath());

		POIFSFileSystem fileSystem = new POIFSFileSystem(fis);

		Workbook wb = new HSSFWorkbook(fileSystem);

		Sheet sheet = wb.getSheetAt(0);

		sheet.getRow(0).getCell(1).setCellValue(excelTop); // excel表头

		Row curRow = null;

		Cell curCell = null;

		for (int i = 0; i < excelData.length; i++) { // 循环数据,依次插入

			curRow = sheet.createRow(startrow + i);

			for (int j = startcol; j < endcol + 1; j++) {

				curCell = curRow.createCell(j);

				curCell.setCellType(Cell.CELL_TYPE_STRING);

				curRow.createCell(j).setCellValue(excelData[i][j]);

				curCell.setCellStyle(createStyleCell(wb));

			}

		}

		FileOutputStream fileOut = new FileOutputStream(newfile.getAbsolutePath());

		fis.close();

		wb.write(fileOut);

        fileOut.close();

		return IcAppCommon.app_excelfile_path + "/" +newfile.getName();

	}





 public static CellStyle createStyleCell(Workbook wb){  

    	HSSFCellStyle cs = (HSSFCellStyle) wb.createCellStyle();  

        cs.setBorderBottom(HSSFCellStyle.BORDER_THIN);

		cs.setBottomBorderColor(HSSFColor.BLACK.index);

		cs.setBorderLeft(HSSFCellStyle.BORDER_THIN);

		cs.setLeftBorderColor(HSSFColor.BLACK.index);

		cs.setBorderRight(HSSFCellStyle.BORDER_THIN);

		cs.setRightBorderColor(HSSFColor.BLACK.index);

		cs.setBorderTop(HSSFCellStyle.BORDER_THIN);

		cs.setTopBorderColor(HSSFColor.BLACK.index);

		cs.setWrapText(true);

        return cs;  

    }