POI Excel合並單元格

Posted on 2007-04-30 13:23 小城阅读(2182) 评论(0) 收藏举报

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("sheet1");
    //合並單元格,下標從0開始
    sheet.addMergedRegion(new Region(0,(short)0,0,(short)2));

    HSSFRow rowT = sheet.createRow(0);
    HSSFCell cellT = rowT.createCell((short)0);
    cellT.setEncoding(HSSFCell.ENCODING_UTF_16);
    cellT.setCellValue("Excel報表標題");