Examples of AreaReference

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

1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
        XSSFWorkbook wb = setupSheet();
        XSSFSheet sheet = wb.getSheetAt(0);

        assertNotNull(wb);
        assertNotNull(sheet);
        XSSFPivotTable pivotTable = sheet.createPivotTable(new AreaReference("A1:B2"), new CellReference("H5"));
        assertNotNull(pivotTable);
        assertTrue(wb.getPivotTables().size() > 0);
        assertNotNull(wb);
        XSSFSheet sheet2 = wb.createSheet();
        XSSFPivotTable pivotTable2 = sheet2.createPivotTable(new AreaReference("A1:B2"), new CellReference("H5"), sheet);
        assertNotNull(pivotTable2);
        assertTrue(wb.getPivotTables().size() > 1);
    }
View Full Code Here

Examples of org.zkoss.poi.ss.util.AreaReference

44
45
46
47
48
49
50
51
52
53
54
   * @param sheet the {@link Worksheet} the Range will refer to.
   * @param reference the area the Range will refer to (e.g. "A1:D4").
   * @return the associated {@link Range} of the specified {@link Worksheet} and area reference string (e.g. "A1:D4").
   */
  public static Range range(Worksheet sheet, String reference) {
    AreaReference ref = getAreaReference(sheet, reference);
    if (ref == null) {
      //try NamedRange
      final Workbook wb = sheet.getWorkbook();
        final Name range = wb.getName(reference);
        if (range != null) {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.