Package org.openxmlformats.schemas.spreadsheetml.x2006.main

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

687
688
689
690
691
692
693
694
695
696
697
        for(int i=fromRow;i<=toRow;i++){
        XSSFRow xrow=(XSSFRow)getRow(i-1);
        if(xrow==null){//create a new Row
           xrow=(XSSFRow)createRow(i-1);
        }       
        CTRow ctrow=xrow.getCTRow();
        short outlineLevel=ctrow.getOutlineLevel();
        ctrow.setOutlineLevel((short)(outlineLevel+1));         
         }
        setSheetFormatPrOutlineLevelRow();
    }
View Full Code Here
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
    public void ungroupRow(int fromRow, int toRow) {
      for(int i=fromRow;i<=toRow;i++){
        XSSFRow xrow=(XSSFRow)getRow(i-1);
        if(xrow!=null){
          CTRow ctrow=xrow.getCTRow();
          short outlinelevel=ctrow.getOutlineLevel();
          ctrow.setOutlineLevel((short)(outlinelevel-1));
          //remove a row only if the row has no cell and if the outline level is 0
          if(ctrow.getOutlineLevel()==0 && xrow.getFirstCellNum()==-1){
            removeRow(xrow);
          }
        }
      }
       setSheetFormatPrOutlineLevelRow();
View Full Code Here
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
     * @param rownum  row number
     * @return High level {@link XSSFRow} object representing a row in the sheet
     * @see #removeRow(org.apache.poi.ss.usermodel.Row)
     */
    public XSSFRow createRow(int rownum) {
        CTRow ctRow;
        XSSFRow prev = _rows.get(rownum);
        if(prev != null){
            ctRow = prev.getCTRow();
            ctRow.set(CTRow.Factory.newInstance());
        } else {
          if(_rows.isEmpty() || rownum > _rows.lastKey()) {
            // we can append the new row at the end
            ctRow = worksheet.getSheetData().addNewRow();
          } else {
View Full Code Here
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
        for (int i = fromRow; i <= toRow; i++) {
            XSSFRow xrow = getRow(i);
            if (xrow == null) {
                xrow = createRow(i);
            }
            CTRow ctrow = xrow.getCTRow();
            short outlineLevel = ctrow.getOutlineLevel();
            ctrow.setOutlineLevel((short) (outlineLevel + 1));
        }
        setSheetFormatPrOutlineLevelRow();
    }
View Full Code Here
2455
2456
2457
2458
2459
2460
2461
2462
2463
2464
2465
2466
2467
2468
2469
     */
    public void ungroupRow(int fromRow, int toRow) {
        for (int i = fromRow; i <= toRow; i++) {
            XSSFRow xrow = getRow(i);
            if (xrow != null) {
                CTRow ctrow = xrow.getCTRow();
                short outlinelevel = ctrow.getOutlineLevel();
                ctrow.setOutlineLevel((short) (outlinelevel - 1));
                //remove a row only if the row has no cell and if the outline level is 0
                if (ctrow.getOutlineLevel() == 0 && xrow.getFirstCellNum() == -1) {
                    removeRow(xrow);
                }
            }
        }
        setSheetFormatPrOutlineLevelRow();
View Full Code Here
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
            XSSFSheet sheet = workbook.createSheet();

        //one level
        sheet.groupRow(9,10);
        assertEquals(2,sheet.getPhysicalNumberOfRows());
        CTRow ctrow = sheet.getRow(9).getCTRow();

        assertNotNull(ctrow);
        assertEquals(10,ctrow.getR());
        assertEquals(1, ctrow.getOutlineLevel());
        assertEquals(1,sheet.getCTWorksheet().getSheetFormatPr().getOutlineLevelRow());

        //two level     
        sheet.groupRow(10,13);
        assertEquals(5,sheet.getPhysicalNumberOfRows());
        ctrow = sheet.getRow(10).getCTRow();
        assertNotNull(ctrow);
        assertEquals(11,ctrow.getR());
        assertEquals(2, ctrow.getOutlineLevel());
        assertEquals(2,sheet.getCTWorksheet().getSheetFormatPr().getOutlineLevelRow());

       
        sheet.ungroupRow(8, 10);
            assertEquals(4,sheet.getPhysicalNumberOfRows());
View Full Code Here
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
        //one level
        sheet.groupRow(9,10);
        assertEquals(2,sheet.rows.size());
        CTRow[]rowArray=sheet.getWorksheet().getSheetData().getRowArray();     
        assertEquals(2,rowArray.length);
        CTRow ctrow=rowArray[0];

        assertNotNull(ctrow);
        assertEquals(9,ctrow.getR());
        assertEquals(1, ctrow.getOutlineLevel());
        assertEquals(1,sheet.getSheetTypeSheetFormatPr().getOutlineLevelRow());

        //two level     
        sheet.groupRow(10,13);
        rowArray=sheet.getWorksheet().getSheetData().getRowArray();     
        assertEquals(5,rowArray.length);
        assertEquals(5,sheet.rows.size());
        ctrow=rowArray[1];
        assertNotNull(ctrow);
        assertEquals(10,ctrow.getR());
        assertEquals(2, ctrow.getOutlineLevel());
        assertEquals(2,sheet.getSheetTypeSheetFormatPr().getOutlineLevelRow());

       
        sheet.ungroupRow(8, 10);
        rowArray=sheet.getWorksheet().getSheetData().getRowArray();     
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
     * @param pos
     * @return  the inserted row
     */
    public XWPFTableRow insertNewTableRow(int pos){
      if(pos >= 0 && pos <= tableRows.size()){
        CTRow row = ctTbl.insertNewTr(pos);
        XWPFTableRow tableRow = new XWPFTableRow(row, this);
        tableRows.add(pos, tableRow);
        return tableRow;
      }
      return null;
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73

    public void testGetText() {
        XWPFDocument doc = new XWPFDocument();
        CTTbl table = CTTbl.Factory.newInstance();
        CTRow row = table.addNewTr();
        CTTc cell = row.addNewTc();
        CTP paragraph = cell.addNewP();
        CTR run = paragraph.addNewR();
        CTText text = run.addNewT();
        text.setStringValue("finally I can write!");
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
    public void testCreateRow() {
        XWPFDocument doc = new XWPFDocument();

        CTTbl table = CTTbl.Factory.newInstance();
        CTRow r1 = table.addNewTr();
        r1.addNewTc().addNewP();
        r1.addNewTc().addNewP();
        CTRow r2 = table.addNewTr();
        r2.addNewTc().addNewP();
        r2.addNewTc().addNewP();
        CTRow r3 = table.addNewTr();
        r3.addNewTc().addNewP();
        r3.addNewTc().addNewP();

        XWPFTable xtab = new XWPFTable(table, doc);
        assertEquals(3, xtab.getNumberOfRows());
        assertNotNull(xtab.getRow(2));
View Full Code Here
TOP

Related Classes of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRow

  • com.narirelays.ems.utils.ExcelUtility
  • org.apache.poi.hssf.extractor.HXFExcelExtractor
  • org.apache.poi.hssf.HSSFXML
  • org.apache.poi.hssf.model.SharedStringsTable
  • org.apache.poi.xssf.eventusermodel.TestReadOnlySharedStringsTable
  • org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator
  • org.apache.poi.xssf.model.CommentsTable
  • org.apache.poi.xssf.model.Control
  • org.apache.poi.xssf.model.Drawing
  • org.apache.poi.xssf.model.ExternalLinksTable
    • Copyright © 2018 www.massapicom. 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.