/** * @deprecated (Aug-2008) use {@link HSSFSheet#getMergedRegion(int)} */ public org.apache.poi.hssf.util.Region getMergedRegionAt(int index) { CellRangeAddress cra = getMergedRegion(index); return new org.apache.poi.hssf.util.Region(cra.getFirstRow(), (short)cra.getFirstColumn(), cra.getLastRow(), (short)cra.getLastColumn()); } /**
/** * @deprecated (Aug-2008) use {@link HSSFSheet#getMergedRegion(int)} */ public org.apache.poi.hssf.util.Region getMergedRegionAt(int index) { CellRangeAddress cra = getMergedRegion(index); return new org.apache.poi.hssf.util.Region(cra.getFirstRow(), (short) cra.getFirstColumn(), cra.getLastRow(), (short) cra.getLastColumn()); }
row = sheet.createRow(++rowNum); cell = row.createCell((short) 0); sheet.addMergedRegion(new Region(rowNum, s1, rowNum, s2)); cellDescr = row.createCell((short) 0); cellDescr.setCellValue("Run-time Parameters"); sheet.addMergedRegion(new Region(rowNum, s1, rowNum, s2)); cellDescr = row.createCell((short) 0); cellDescr.setCellValue("Run-time Parameters");
cellNum = 0; row.createCell((short) cellNum).setCellValue(header); sheet.addMergedRegion(new Region(rowNum, (short) cellNum, rowNum, (short) (columnRows))); rowNum += 1; row = sheet.createRow(rowNum); cellNum = 0; row.createCell((short) cellNum).setCellValue(subtitle); sheet.addMergedRegion(new Region(rowNum, (short) cellNum, rowNum, (short) (columnRows))); rowNum += 1; row.createCell((short) cellNum+k); sheet.addMergedRegion(new Region(rowNum, (short) cellNum, rowNum, (short) (cellNum+colSpan))); cellNum = 0; row.createCell((short) cellNum).setCellValue(footer); sheet.addMergedRegion(new Region(rowNum, (short) cellNum, rowNum, (short) (columnRows))); String disclaimer = Globals.getFooterFirstLine() + " " + Globals.getFooterSecondLine(); row.createCell((short) cellNum).setCellValue(disclaimer); sheet.addMergedRegion(new Region(rowNum, (short) cellNum, rowNum, (short) (columnRows))); rowNum += 1;
short s1 = 0, s2 = (short) (col-1); rowNum += 1; sheet.addMergedRegion(new Region(rowNum, s1, rowNum, s2)); HSSFRow row = null, row1 = null; sheet.addMergedRegion(new Region(rowNum, s1, rowNum, s2)); HSSFCellStyle styleDescription = wb.createCellStyle(); styleDescription.setAlignment(HSSFCellStyle.ALIGN_CENTER); rowNum += 1; row = sheet.createRow(rowNum); sheet.addMergedRegion(new Region(rowNum, s1, rowNum, s2)); HSSFCellStyle styleDescription = wb.createCellStyle(); styleDescription.setAlignment(HSSFCellStyle.ALIGN_CENTER);