Package org.xlsx4j.sml

Examples of org.xlsx4j.sml.Cell

53
54
55
56
57
58
59
60
61
62
63
64
          // 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);
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
      }

      private static Cell createCell(String content) {

          Cell cell = Context.getsmlObjectFactory().createCell();

          CTXstringWhitespace ctx = Context.getsmlObjectFactory().createCTXstringWhitespace();
          ctx.setValue(content);

          CTRst ctrst = new CTRst();
          ctrst.setT(ctx);

          cell.setT(STCellType.INLINE_STR);
          cell.setIs(ctrst); // add ctrst as inline string

          return cell;

      }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
         
    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
35
36
37
38
39
40
41
42
43
44
45
46
    // 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!"));
   
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
    // See http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2011/11/22/screen-cast-write-simpler-spreadsheetml-when-generating-spreadsheets.aspx
    // and http://www.docx4java.org/forums/xlsx-java-f15/cells-with-character-values-t874.html
   */
  private static Cell createCell(String content) {

    Cell cell = Context.getsmlObjectFactory().createCell();
   
    CTXstringWhitespace ctx = Context.getsmlObjectFactory().createCTXstringWhitespace();
    ctx.setValue(content);
   
    CTRst ctrst = new CTRst();
    ctrst.setT(ctx);

    cell.setT(STCellType.INLINE_STR);
    cell.setIs(ctrst); // add ctrst as inline string
   
    return cell;
   
  }
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
                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());
                    } else {
                        Assert.assertEquals(etalonCell.getV(), resultCell.getV());
                    }
                }
            }
        }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
    // 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!"));
   
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
    // See http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2011/11/22/screen-cast-write-simpler-spreadsheetml-when-generating-spreadsheets.aspx
    // and http://www.docx4java.org/forums/xlsx-java-f15/cells-with-character-values-t874.html
   */
  private static Cell createCell(String content) {

    Cell cell = Context.getsmlObjectFactory().createCell();
   
    CTXstringWhitespace ctx = Context.getsmlObjectFactory().createCTXstringWhitespace();
    ctx.setValue(content);
   
    CTRst ctrst = new CTRst();
    ctrst.setT(ctx);

    cell.setT(STCellType.INLINE_STR);
    cell.setIs(ctrst); // add ctrst as inline string
   
    return cell;
   
  }}
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
         
    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
58
59
60
61
62
63
64
65
66
67
68
69
      // 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);
View Full Code Here
TOP

Related Classes of org.xlsx4j.sml.Cell

  • 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.