Examples of org.apache.poi.ss.util.Region

org.apache.poi.ss.util.Region
Represents a from/to row/col square. This is a object primitive that can be used to represent row,col - row,col just as one would use String to represent a string of characters. Its really only useful for HSSF though. @author Andrew C. Oliver acoliver at apache dot org @deprecated (Aug-2008) use {@link CellRangeAddress}

    return worksheet.getPageMargins();
  }


    public Region getMergedRegionAt(int index) {
      CTMergeCell ctMergeCell = getMergedCells().getMergeCellArray(index);
      return new Region(ctMergeCell.getRef());
    }

View Full Code Here

    public void testNewMergedRegionAt() {
      Workbook workbook = new XSSFWorkbook();
      CTSheet ctSheet = CTSheet.Factory.newInstance();
      CTWorksheet ctWorksheet = CTWorksheet.Factory.newInstance();
      XSSFSheet sheet = new XSSFSheet(ctSheet, ctWorksheet, (XSSFWorkbook) workbook);
      Region region = new Region("B2:D4");
      sheet.addMergedRegion(region);
      assertEquals("B2:D4", sheet.getMergedRegionAt(0).getRegionRef());
    }

View Full Code Here

      Workbook workbook = new XSSFWorkbook();
      CTSheet ctSheet = CTSheet.Factory.newInstance();
      CTWorksheet ctWorksheet = CTWorksheet.Factory.newInstance();
      XSSFSheet sheet = new XSSFSheet(ctSheet, ctWorksheet, (XSSFWorkbook) workbook);
      assertEquals(0, sheet.getNumMergedRegions());
      Region region = new Region("B2:D4");
      sheet.addMergedRegion(region);
      assertEquals(1, sheet.getNumMergedRegions());
    }

View Full Code Here

    public void testRemoveMergedRegion() {
      Workbook workbook = new XSSFWorkbook();
      CTSheet ctSheet = CTSheet.Factory.newInstance();
      CTWorksheet ctWorksheet = CTWorksheet.Factory.newInstance();
      XSSFSheet sheet = new XSSFSheet(ctSheet, ctWorksheet, (XSSFWorkbook) workbook);
      Region region_1 = new Region("A1:B2");
      Region region_2 = new Region("C3:D4");
      Region region_3 = new Region("E5:F6");
      sheet.addMergedRegion(region_1);
      sheet.addMergedRegion(region_2);
      sheet.addMergedRegion(region_3);
      assertEquals("C3:D4", ctWorksheet.getMergeCells().getMergeCellArray(1).getRef());
      assertEquals(3, sheet.getNumMergedRegions());

View Full Code Here

0 1 2

TOP

Related Classes of org.apache.poi.ss.util.Region

org.apache.poi.hssf.dev.HSSF

org.apache.poi.hssf.record.cf.CellRange

org.apache.poi.hssf.usermodel.examples.MergedCells

org.apache.poi.hssf.usermodel.HSSFSheet

org.apache.poi.hssf.usermodel.TestBugs

org.apache.poi.hssf.usermodel.TestCloneSheet

org.apache.poi.hssf.usermodel.TestDataValidation

org.apache.poi.hssf.usermodel.TestHSSFConditionalFormatting

org.apache.poi.hssf.usermodel.TestHSSFSheet

org.apache.poi.hssf.usermodel.TestWorkbook

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.