Examples of CTSheetData

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetData

2578
2579
2580
2581
2582
2583
2584
2585
2586
2587
2588
2589
2590
2591
2592
2593
2594
2595
2596
2597
2598
2599
2600
2601
2602
2603
2604
2605
2606
2607
2608
2609
2610
    /**
     * ensure that the array of CTRow written to CTSheetData is ordered by row index
     */
    private void ensureRowOrdering(){
        CTSheetData sheetData = worksheet.getSheetData();
        // check if row indexes in CTSheetData match the internal model:
        // rows in the internal model (_rows) are always ordered while
        // CTRow beans held by CTSheetData may be not, for example, user can
        // insert rows in random order, shift rows after insertion, etc.
        boolean isOrdered = true;
        if(sheetData.sizeOfRowArray() != _rows.size()) isOrdered = false;
        else {
            int i = 0;
            for (XSSFRow row : _rows.values()) {
                CTRow c1 = row.getCTRow();
                CTRow c2 = sheetData.getRowArray(i++);
                if (c1.getR() != c2.getR()){
                    isOrdered = false;
                    break;
                }
            }
        }
       
        if(!isOrdered){
            CTRow[] cArray = new CTRow[_rows.size()];
            int i = 0;
            for(XSSFRow row : _rows.values()){
                cArray[i++] = row.getCTRow();
            }
            sheetData.setRowArray(cArray);
        }
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetData

2313
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
                ctHls[i] = hyperlink.getCTHyperlink();
            }
            worksheet.getHyperlinks().setHyperlinkArray(ctHls);
        }

        CTSheetData sheetData = worksheet.getSheetData();
        ArrayList<CTRow> rArray = new ArrayList<CTRow>(rows.size());
        for(XSSFRow row : rows.values()){
            row.onDocumentWrite();
            rArray.add(row.getCTRow());
        }
        sheetData.setRowArray(rArray.toArray(new CTRow[rArray.size()]));

        XmlOptions xmlOptions = new XmlOptions(DEFAULT_XML_OPTIONS);
        xmlOptions.setSaveSyntheticDocumentElement(new QName(CTWorksheet.type.getName().getNamespaceURI(), "worksheet"));
        Map map = new HashMap();
        map.put(STRelationshipId.type.getName().getNamespaceURI(), "r");
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetData

959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
    @Test
    public void createRow() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet();
        CTWorksheet wsh = sheet.getCTWorksheet();
        CTSheetData sheetData = wsh.getSheetData();
        assertEquals(0, sheetData.sizeOfRowArray());

        XSSFRow row1 = sheet.createRow(2);
        row1.createCell(2);
        row1.createCell(1);

        XSSFRow row2 = sheet.createRow(1);
        row2.createCell(2);
        row2.createCell(1);
        row2.createCell(0);

        XSSFRow row3 = sheet.createRow(0);
        row3.createCell(3);
        row3.createCell(0);
        row3.createCell(2);
        row3.createCell(5);


        List<CTRow> xrow = sheetData.getRowList();
        assertEquals(3, xrow.size());

        //rows are sorted: {0, 1, 2}
        assertEquals(4, xrow.get(0).sizeOfCArray());
        assertEquals(1, xrow.get(0).getR());
        assertTrue(xrow.get(0).equals(row3.getCTRow()));

        assertEquals(3, xrow.get(1).sizeOfCArray());
        assertEquals(2, xrow.get(1).getR());
        assertTrue(xrow.get(1).equals(row2.getCTRow()));

        assertEquals(2, xrow.get(2).sizeOfCArray());
        assertEquals(3, xrow.get(2).getR());
        assertTrue(xrow.get(2).equals(row1.getCTRow()));

        List<CTCell> xcell = xrow.get(0).getCList();
        assertEquals("D1", xcell.get(0).getR());
        assertEquals("A1", xcell.get(1).getR());
        assertEquals("C1", xcell.get(2).getR());
        assertEquals("F1", xcell.get(3).getR());

        //re-creating a row does NOT add extra data to the parent
        row2 = sheet.createRow(1);
        assertEquals(3, sheetData.sizeOfRowArray());
        //existing cells are invalidated
        assertEquals(0, sheetData.getRowArray(1).sizeOfCArray());
        assertEquals(0, row2.getPhysicalNumberOfCells());

        workbook = XSSFTestDataSamples.writeOutAndReadBack(workbook);
        sheet = workbook.getSheetAt(0);
        wsh = sheet.getCTWorksheet();
        xrow = sheetData.getRowList();
        assertEquals(3, xrow.size());

        //rows are sorted: {0, 1, 2}
        assertEquals(4, xrow.get(0).sizeOfCArray());
        assertEquals(1, xrow.get(0).getR());
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetData

962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
    @Test
    public void createRow() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet();
        CTWorksheet wsh = sheet.getCTWorksheet();
        CTSheetData sheetData = wsh.getSheetData();
        assertEquals(0, sheetData.sizeOfRowArray());

        XSSFRow row1 = sheet.createRow(2);
        row1.createCell(2);
        row1.createCell(1);

        XSSFRow row2 = sheet.createRow(1);
        row2.createCell(2);
        row2.createCell(1);
        row2.createCell(0);

        XSSFRow row3 = sheet.createRow(0);
        row3.createCell(3);
        row3.createCell(0);
        row3.createCell(2);
        row3.createCell(5);


        List<CTRow> xrow = sheetData.getRowList();
        assertEquals(3, xrow.size());

        //rows are sorted: {0, 1, 2}
        assertEquals(4, xrow.get(0).sizeOfCArray());
        assertEquals(1, xrow.get(0).getR());
        assertTrue(xrow.get(0).equals(row3.getCTRow()));

        assertEquals(3, xrow.get(1).sizeOfCArray());
        assertEquals(2, xrow.get(1).getR());
        assertTrue(xrow.get(1).equals(row2.getCTRow()));

        assertEquals(2, xrow.get(2).sizeOfCArray());
        assertEquals(3, xrow.get(2).getR());
        assertTrue(xrow.get(2).equals(row1.getCTRow()));

        List<CTCell> xcell = xrow.get(0).getCList();
        assertEquals("D1", xcell.get(0).getR());
        assertEquals("A1", xcell.get(1).getR());
        assertEquals("C1", xcell.get(2).getR());
        assertEquals("F1", xcell.get(3).getR());

        //re-creating a row does NOT add extra data to the parent
        row2 = sheet.createRow(1);
        assertEquals(3, sheetData.sizeOfRowArray());
        //existing cells are invalidated
        assertEquals(0, sheetData.getRowArray(1).sizeOfCArray());
        assertEquals(0, row2.getPhysicalNumberOfCells());

        workbook = XSSFTestDataSamples.writeOutAndReadBack(workbook);
        sheet = workbook.getSheetAt(0);
        wsh = sheet.getCTWorksheet();
        xrow = sheetData.getRowList();
        assertEquals(3, xrow.size());

        //rows are sorted: {0, 1, 2}
        assertEquals(4, xrow.get(0).sizeOfCArray());
        assertEquals(1, xrow.get(0).getR());
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetData

2313
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
                ctHls[i] = hyperlink.getCTHyperlink();
            }
            worksheet.getHyperlinks().setHyperlinkArray(ctHls);
        }

        CTSheetData sheetData = worksheet.getSheetData();
        ArrayList<CTRow> rArray = new ArrayList<CTRow>(rows.size());
        for(XSSFRow row : rows.values()){
            row.onDocumentWrite();
            rArray.add(row.getCTRow());
        }
        sheetData.setRowArray(rArray.toArray(new CTRow[rArray.size()]));

        XmlOptions xmlOptions = new XmlOptions(DEFAULT_XML_OPTIONS);
        xmlOptions.setSaveSyntheticDocumentElement(new QName(CTWorksheet.type.getName().getNamespaceURI(), "worksheet"));
        Map map = new HashMap();
        map.put(STRelationshipId.type.getName().getNamespaceURI(), "r");
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetData

2462
2463
2464
2465
2466
2467
2468
2469
2470
2471
2472
2473
2474
2475
2476
2477
2478
2479
2480
2481
2482
2483
2484
2485
2486
2487
2488
2489
2490
2491
2492
2493
2494
2495
    /**
     * ensure that the array of CTRow written to CTSheetData is ordered by row index
     */
    private void ensureRowOrdering(){
        CTSheetData sheetData = worksheet.getSheetData();
        // check if row indexes in CTSheetData match the internal model:
        // rows in the internal model (_rows) are always ordered while
        // CTRow beans held by CTSheetData may be not, for example, user can
        // insert rows in random order, shift rows after insertion, etc.
        boolean isOrdered = true;
        if(sheetData.sizeOfRowArray() != _rows.size()) isOrdered = false;
        else {
            int i = 0;
            CTRow[] xrow = sheetData.getRowArray();
            for (XSSFRow row : _rows.values()) {
                CTRow c1 = row.getCTRow();
                CTRow c2 = xrow[i++];
                if (c1.getR() != c2.getR()){
                    isOrdered = false;
                    break;
                }
            }
        }
       
        if(!isOrdered){
            CTRow[] cArray = new CTRow[_rows.size()];
            int i = 0;
            for(XSSFRow row : _rows.values()){
                cArray[i++] = row.getCTRow();
            }
            sheetData.setRowArray(cArray);
        }
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetData

2467
2468
2469
2470
2471
2472
2473
2474
2475
2476
2477
2478
2479
2480
2481
2482
2483
2484
2485
2486
2487
2488
2489
2490
2491
2492
2493
2494
2495
2496
2497
2498
2499
    /**
     * ensure that the array of CTRow written to CTSheetData is ordered by row index
     */
    private void ensureRowOrdering(){
        CTSheetData sheetData = worksheet.getSheetData();
        // check if row indexes in CTSheetData match the internal model:
        // rows in the internal model (_rows) are always ordered while
        // CTRow beans held by CTSheetData may be not, for example, user can
        // insert rows in random order, shift rows after insertion, etc.
        boolean isOrdered = true;
        if(sheetData.sizeOfRowArray() != _rows.size()) isOrdered = false;
        else {
            int i = 0;
            for (XSSFRow row : _rows.values()) {
                CTRow c1 = row.getCTRow();
                CTRow c2 = sheetData.getRowArray(i++);
                if (c1.getR() != c2.getR()){
                    isOrdered = false;
                    break;
                }
            }
        }
       
        if(!isOrdered){
            CTRow[] cArray = new CTRow[_rows.size()];
            int i = 0;
            for(XSSFRow row : _rows.values()){
                cArray[i++] = row.getCTRow();
            }
            sheetData.setRowArray(cArray);
        }
    }
View Full Code Here

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheetData

982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
    @SuppressWarnings("deprecation")
    public void createRow() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        XSSFSheet sheet = workbook.createSheet();
        CTWorksheet wsh = sheet.getCTWorksheet();
        CTSheetData sheetData = wsh.getSheetData();
        assertEquals(0, sheetData.sizeOfRowArray());

        XSSFRow row1 = sheet.createRow(2);
        row1.createCell(2);
        row1.createCell(1);

        XSSFRow row2 = sheet.createRow(1);
        row2.createCell(2);
        row2.createCell(1);
        row2.createCell(0);

        XSSFRow row3 = sheet.createRow(0);
        row3.createCell(3);
        row3.createCell(0);
        row3.createCell(2);
        row3.createCell(5);


        CTRow[] xrow = sheetData.getRowArray();
        assertEquals(3, xrow.length);

        //rows are sorted: {0, 1, 2}
        assertEquals(4, xrow[0].sizeOfCArray());
        assertEquals(1, xrow[0].getR());
        assertTrue(xrow[0].equals(row3.getCTRow()));

        assertEquals(3, xrow[1].sizeOfCArray());
        assertEquals(2, xrow[1].getR());
        assertTrue(xrow[1].equals(row2.getCTRow()));

        assertEquals(2, xrow[2].sizeOfCArray());
        assertEquals(3, xrow[2].getR());
        assertTrue(xrow[2].equals(row1.getCTRow()));

        CTCell[] xcell = xrow[0].getCArray();
        assertEquals("D1", xcell[0].getR());
        assertEquals("A1", xcell[1].getR());
        assertEquals("C1", xcell[2].getR());
        assertEquals("F1", xcell[3].getR());

        //re-creating a row does NOT add extra data to the parent
        row2 = sheet.createRow(1);
        assertEquals(3, sheetData.sizeOfRowArray());
        //existing cells are invalidated
        assertEquals(0, sheetData.getRowArray(1).sizeOfCArray());
        assertEquals(0, row2.getPhysicalNumberOfCells());

        workbook = XSSFTestDataSamples.writeOutAndReadBack(workbook);
        sheet = workbook.getSheetAt(0);
        wsh = sheet.getCTWorksheet();
        xrow = sheetData.getRowArray();
        assertEquals(3, xrow.length);

        //rows are sorted: {0, 1, 2}
        assertEquals(4, xrow[0].sizeOfCArray());
        assertEquals(1, xrow[0].getR());
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.