Example usage for org.apache.poi.xssf.usermodel XSSFSheet getRow

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFSheet getRow.

Prototype

@Override
public XSSFRow getRow(int rownum) 

Source Link

Document

Returns the logical row ( 0-based).

Usage

From source file:uk.ac.manchester.cs.owl.semspreadsheets.model.xssf.impl.WorkbookXSSFImpl.java

License:Open Source License

public void visit(SetCellValue setCellValue) {
    XSSFSheet xssfSheet = workbook.getSheet(setCellValue.getSheet().getName());
    XSSFRow xssfRow = xssfSheet.getRow(setCellValue.getRow());
    if (xssfRow == null && setCellValue.getNewValue() != null) {
        xssfRow = xssfSheet.createRow(setCellValue.getRow());
    }//from w ww.  j a va  2  s.  co  m
    XSSFCell xssfCell = xssfRow.getCell(setCellValue.getCol());
    if (xssfCell == null && setCellValue.getNewValue() != null) {
        xssfCell = xssfRow.createCell(setCellValue.getCol());
    }
    if (xssfCell != null) {
        if (setCellValue.getNewValue() != null) {
            xssfCell.setCellValue(new XSSFRichTextString(setCellValue.getNewValue().toString()));
        } else {
            xssfRow.removeCell(xssfCell);
        }
    }
}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.AutoFilterTest.java

License:Open Source License

@Test
public void autoFilter() throws Exception {
    debug = false;// w ww .  j a va2s.c o  m
    autoFilter = true;
    InputStream inputStream = runAndRenderReport("SideBySideMultiColumns.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Sheet0", workbook.getSheetAt(0).getSheetName());

        XSSFSheet sheet = workbook.getSheetAt(0);
        assertEquals(124, this.firstNullRow(sheet));

        assertEquals(297, sheet.getRow(0).getHeightInPoints(), 1.0);
        assertEquals(2048, sheet.getColumnWidth(0));
        assertEquals(6196, sheet.getColumnWidth(1));
        assertEquals(3749, sheet.getColumnWidth(2));
        assertEquals(2396, sheet.getColumnWidth(3));
        assertEquals(4516, sheet.getColumnWidth(4));
        assertEquals(7072, sheet.getColumnWidth(5));
        assertEquals(2048, sheet.getColumnWidth(6));
        assertEquals(3509, sheet.getColumnWidth(7));
        assertEquals(2048, sheet.getColumnWidth(8));
        assertEquals(2314, sheet.getColumnWidth(9));
        assertEquals(2338, sheet.getColumnWidth(10));
        assertEquals(2048, sheet.getColumnWidth(11));
        assertEquals(2048, sheet.getColumnWidth(12));

        assertTrue(mergedRegion(sheet, 0, 0, 0, 5));
        assertTrue(mergedRegion(sheet, 0, 7, 0, 12));

        XSSFName name = workbook.getName(XSSFName.BUILTIN_FILTER_DB);
        assertEquals(0, name.getSheetIndex());
        assertEquals("Sheet0!$A$1:$M$2", name.getRefersToFormula());
    } finally {
        inputStream.close();
    }
}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Groupings.java

License:Open Source License

@Test
public void testGroupings() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("Grouping.rptdesign", "xlsx");
    assertNotNull(inputStream);/*w  w  w.  j  a  va  2s  .  c o m*/
    try {

        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(3, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFSheet sheet1 = workbook.getSheetAt(1);
        XSSFSheet sheet2 = workbook.getSheetAt(2);
        assertEquals("HeaderAndFooter", sheet0.getSheetName());

        int rowNum0 = 1;
        int rowNum1 = 1;
        int rowNum2 = 1;
        for (int i = 1; i < 9; ++i) {
            System.out.println("i==" + i);
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 1, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
            for (int j = 0; j < i; ++j) {
                assertEquals("rowNum=" + rowNum0, 1, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
                if (j < i - 1) {
                    assertEquals("rowNum=" + rowNum1, i == 1 ? 0 : 1,
                            sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
                    assertEquals("rowNum=" + rowNum2, i == 1 ? 0 : 1,
                            sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
                }
            }
            assertEquals("rowNum=" + rowNum0, 1, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 1, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
        }
        assertTrue(rowNum0 > 50);
        assertTrue(rowNum1 > 40);
        assertTrue(rowNum2 > 40);

    } finally {
        inputStream.close();
    }
}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Groupings.java

License:Open Source License

@Test
public void testGroupingsBlockedByContext() throws BirtException, IOException {

    disableGrouping = Boolean.TRUE;
    InputStream inputStream = runAndRenderReport("Grouping.rptdesign", "xlsx");
    disableGrouping = null;//www .j  a  v  a 2 s.  c  o m
    assertNotNull(inputStream);
    try {

        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(3, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFSheet sheet1 = workbook.getSheetAt(1);
        XSSFSheet sheet2 = workbook.getSheetAt(2);
        assertEquals("HeaderAndFooter", sheet0.getSheetName());

        int rowNum0 = 1;
        int rowNum1 = 1;
        int rowNum2 = 1;
        for (int i = 1; i < 9; ++i) {
            System.out.println("i==" + i);
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
            for (int j = 0; j < i; ++j) {
                assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
                if (j < i - 1) {
                    assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
                    assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
                }
            }
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
        }
        assertTrue(rowNum0 > 50);
        assertTrue(rowNum1 > 40);
        assertTrue(rowNum2 > 40);

    } finally {
        inputStream.close();
    }
}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Groupings.java

License:Open Source License

@Test
public void testGroupingsBlockedByReport() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("GroupingDisabledAtReport.rptdesign", "xlsx");
    assertNotNull(inputStream);// w  w w  .  jav a  2  s.c o  m
    try {

        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(3, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFSheet sheet1 = workbook.getSheetAt(1);
        XSSFSheet sheet2 = workbook.getSheetAt(2);
        assertEquals("HeaderAndFooter", sheet0.getSheetName());

        int rowNum0 = 1;
        int rowNum1 = 1;
        int rowNum2 = 1;
        for (int i = 1; i < 9; ++i) {
            System.out.println("i==" + i);
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
            for (int j = 0; j < i; ++j) {
                assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
                if (j < i - 1) {
                    assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
                    assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
                }
            }
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
        }
        assertTrue(rowNum0 > 50);
        assertTrue(rowNum1 > 40);
        assertTrue(rowNum2 > 40);

    } finally {
        inputStream.close();
    }
}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Groupings.java

License:Open Source License

@Test
public void testGroupingsBlockedByTable() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("GroupingDisabledAtTable.rptdesign", "xlsx");
    assertNotNull(inputStream);/*from  w w w. j a v  a2s.  com*/
    try {

        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(3, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);
        XSSFSheet sheet1 = workbook.getSheetAt(1);
        XSSFSheet sheet2 = workbook.getSheetAt(2);
        assertEquals("HeaderAndFooter", sheet0.getSheetName());

        int rowNum0 = 1;
        int rowNum1 = 1;
        int rowNum2 = 1;
        for (int i = 1; i < 9; ++i) {
            System.out.println("i==" + i);
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 1, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
            for (int j = 0; j < i; ++j) {
                assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
                if (j < i - 1) {
                    assertEquals("rowNum=" + rowNum1, i == 1 ? 0 : 1,
                            sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
                    assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
                }
            }
            assertEquals("rowNum=" + rowNum0, 0, sheet0.getRow(rowNum0++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum1, 0, sheet1.getRow(rowNum1++).getCTRow().getOutlineLevel());
            assertEquals("rowNum=" + rowNum2, 0, sheet2.getRow(rowNum2++).getCTRow().getOutlineLevel());
        }
        assertTrue(rowNum0 > 50);
        assertTrue(rowNum1 > 40);
        assertTrue(rowNum2 > 40);

    } finally {
        inputStream.close();
    }
}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testHeader() throws Exception {

    debug = false;/*from   w  ww . j  ava 2 s .  co  m*/
    groupSummaryHeader = true;
    InputStream inputStream = runAndRenderReport("Issue55.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(8).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testFooter() throws Exception {

    debug = false;//from w w w  .j  a va2 s .c o  m
    groupSummaryHeader = false;
    InputStream inputStream = runAndRenderReport("Issue55.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(!groupSummaryHeader, workbook.getSheetAt(0).getRowSumsBelow());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(8).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testHeaderHierarchy() throws Exception {

    debug = false;//from w w  w .  j a  v a 2  s.com
    groupSummaryHeader = true;
    InputStream inputStream = runAndRenderReport("Issue55GroupHierarchy.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        /*         for( int i = 0; i < 64; ++i ) {
                    System.out.println( "assertEquals( " + sheet0.getRow( i ).getCTRow().getOutlineLevel() + ", sheet0.getRow( " + i + " ).getCTRow().getOutlineLevel() );" );
                 }
        */
        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(8).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(9).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(10).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(11).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(12).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(13).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(14).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(15).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(16).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(17).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(18).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(19).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(20).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(21).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(22).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(23).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(24).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(25).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(26).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(27).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(28).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(29).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(30).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(31).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(32).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(33).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(34).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(35).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(36).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(37).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(38).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(39).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(40).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(41).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(42).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(43).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(44).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(45).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(46).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(47).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(48).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(49).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(50).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(51).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(52).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(53).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(54).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(55).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(56).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(57).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(58).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(59).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(60).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(61).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(62).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(63).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.Issue55GroupsNotWorkingCorrectly.java

License:Open Source License

@Test
public void testFooterHierarchyWithHeader() throws Exception {

    /*//w w  w  .j a v a2 s .co  m
     *  Note that the results of this test are a yucky mess
     *  
     *  Excel groups with a summary row above or below the data rows.
     *  Each group has to have a distinct summary row - if you have two groups that try to end with the same summary row Excel represents them like the image on the right (you can still hide with the controls on the top of the grouping column, but not with the individual expand/collapse controls).
       *
     *   You can do one of three things:
     *   
     *       Give each group level a header row and set ExcelEmitter.GroupSummaryHeader.
     *       Give each group level a footer row and don't set ExcelEmitter.GroupSummaryHeader.
     *       Accept that you are going to get something odd :)
     *  
     */

    debug = false;
    groupSummaryHeader = false;
    InputStream inputStream = runAndRenderReport("Issue55GroupHierarchy.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals(!groupSummaryHeader, workbook.getSheetAt(0).getRowSumsBelow());

        XSSFSheet sheet0 = workbook.getSheetAt(0);

        assertEquals(!groupSummaryHeader, sheet0.getRowSumsBelow());

        /*         for( int i = 0; i < 64; ++i ) {
                    System.out.println( "assertEquals( " + sheet0.getRow( i ).getCTRow().getOutlineLevel() + ", sheet0.getRow( " + i + " ).getCTRow().getOutlineLevel() );" );
                 }
        */
        assertEquals(0, sheet0.getRow(0).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(1).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(2).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(3).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(4).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(5).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(6).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(7).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(8).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(9).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(10).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(11).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(12).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(13).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(14).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(15).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(16).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(17).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(18).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(19).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(20).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(21).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(22).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(23).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(24).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(25).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(26).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(27).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(28).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(29).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(30).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(31).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(32).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(33).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(34).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(35).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(36).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(37).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(38).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(39).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(40).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(41).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(42).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(43).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(44).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(45).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(46).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(47).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(48).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(49).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(50).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(51).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(52).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(53).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(54).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(55).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(56).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(57).getCTRow().getOutlineLevel());
        assertEquals(0, sheet0.getRow(58).getCTRow().getOutlineLevel());
        assertEquals(1, sheet0.getRow(59).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(60).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(61).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(62).getCTRow().getOutlineLevel());
        assertEquals(2, sheet0.getRow(63).getCTRow().getOutlineLevel());

    } finally {
        inputStream.close();
    }

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• »