Package org.xlsx4j.sml

Examples of org.xlsx4j.sml.Row

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
          // Minimal content already present
          SheetData sheetData = sheet.getContents().getSheetData();

          // Now add
          Row row = Context.getsmlObjectFactory().createRow();
          Cell cell = Context.getsmlObjectFactory().createCell();
          cell.setV("1234");
          row.getC().add(cell);


          row.getC().add(createCell("hello world!"));
          sheetData.getRow().add(row);
         
          // ADD A COMMENT TO CELL A1
          CommentsPart cp = new CommentsPart();
          cp.setContents(createComment("A1"));
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
    format.setCustomHeight(Boolean.TRUE);
    sheet.getJaxbElement().setSheetFormatPr(format);
         
    SheetData sheetData = sheet.getJaxbElement().getSheetData();
               
    Row row = Context.getsmlObjectFactory().createRow();
         
    row.setHt(66.0);
    row.setCustomHeight(Boolean.TRUE);
    row.setR(1L);
         
    Cell cell1 = Context.getsmlObjectFactory().createCell();
    cell1.setV("1234");
    row.getC().add(cell1);
         
    Cell cell2 = Context.getsmlObjectFactory().createCell();
    cell2.setV("56");
    row.getC().add(cell2);
    sheetData.getRow().add(row);
               
    SaveToZipFile saver = new SaveToZipFile(pkg);
    saver.save( System.getProperty("user.dir") + "/sheet10.xlsx");
  }
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
   
    // Minimal content already present
    SheetData sheetData = sheet.getJaxbElement().getSheetData();
       
    // Now add
    Row row = Context.getsmlObjectFactory().createRow();
    Cell cell = Context.getsmlObjectFactory().createCell();
    cell.setV("1234");
    row.getC().add(cell);
   
   
    row.getC().add(createCell("hello world!"));
   
    sheetData.getRow().add(row);
  }
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
193
194
195
            Document.SheetWrapper etalonWorksheet = etalonWorksheets.get(i);

            List<Row> resultRows = resultWorksheet.getWorksheet().getJaxbElement().getSheetData().getRow();
            List<Row> etalonRows = etalonWorksheet.getWorksheet().getJaxbElement().getSheetData().getRow();
            for (int j = 0, rowSize = resultRows.size(); j < rowSize; j++) {
                Row resultRow = resultRows.get(j);
                Row etalonRow = etalonRows.get(j);
                List<Cell> resultCells = resultRow.getC();
                List<Cell> etalonCells = etalonRow.getC();
                for (int i1 = 0, cSize = etalonCells.size(); i1 < cSize; i1++) {
                    Cell resultCell = resultCells.get(i1);
                    Cell etalonCell = etalonCells.get(i1);
                    if (resultCell.getF() != null) {
                        Assert.assertEquals(etalonCell.getF().getValue(), resultCell.getF().getValue());
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
   
    // Minimal content already present
    SheetData sheetData = sheet.getJaxbElement().getSheetData();
       
    // Now add
    Row row = Context.getsmlObjectFactory().createRow();
    Cell cell = Context.getsmlObjectFactory().createCell();
    cell.setV("1234");
    row.getC().add(cell);
   
   
    row.getC().add(createCell("hello world!"));
   
    sheetData.getRow().add(row);
  }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
 
      // Minimal content already present
      SheetData sheetData = sheet.getContents().getSheetData();
 
      // Now add
      Row row = Context.getsmlObjectFactory().createRow();
      Cell cell = Context.getsmlObjectFactory().createCell();
      cell.setV("1234");
      row.getC().add(cell);
 
 
      row.getC().add(createCell("hello world!"));
      sheetData.getRow().add(row);
     
      // ADD A COMMENT TO CELL A1
      CommentsPart cp = new CommentsPart();
      cp.setContents(createComment("A1"));
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
    format.setCustomHeight(Boolean.TRUE);
    sheet.getJaxbElement().setSheetFormatPr(format);
         
    SheetData sheetData = sheet.getJaxbElement().getSheetData();
               
    Row row = Context.getsmlObjectFactory().createRow();
         
    row.setHt(66.0);
    row.setCustomHeight(Boolean.TRUE);
    row.setR(1L);
         
    Cell cell1 = Context.getsmlObjectFactory().createCell();
    cell1.setV("1234");
    row.getC().add(cell1);
         
    Cell cell2 = Context.getsmlObjectFactory().createCell();
    cell2.setV("56");
    row.getC().add(cell2);
    sheetData.getRow().add(row);
               
    SaveToZipFile saver = new SaveToZipFile(pkg);
    saver.save( System.getProperty("user.dir") + "/data/xlsx4j/RowHeight-Xlsx4j.xlsx");
  }
View Full Code Here
TOP

Related Classes of org.xlsx4j.sml.Row

  • integration.XlsxIntegrationTest
  • org.xlsx4j.samples.CreateSimpleSpreadsheet
  • org.xlsx4j.samples.RowHeight
  • org.xlsx4j.samples.XlsxAddComment
  • xlsx4j.workingwithworkbook.NewSpreadSheetXlsx4j
  • xlsx4j.workingwithworksheet.AddCommentsXlsx4j
  • xlsx4j.workingwithworksheet.HeightAdjustmentXlsx4j
    • 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.