Package org.docx4j.openpackaging.parts.SpreadsheetML

Examples of org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart

126
127
128
129
130
131
132
133
134
135
136
137
138
    while(it.hasNext()) {
      Map.Entry<PartName, Part> pairs = it.next();
     
      if (partsMap.get(pairs.getKey()) instanceof WorksheetPart) {
       
        WorksheetPart wsp = (WorksheetPart) partsMap.get(pairs.getKey()) ;
       
        List<Row> rows = wsp.getJaxbElement().getSheetData().getRow();

        for (Row row : rows) {
          List<Cell> cells = row.getC();
          for (Cell cell : cells)
          {
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
 
    String outputfilepath = System.getProperty("user.dir") + "/OUT_Xlsx4JAddImage.xlsx";
    String imagefilePath = System.getProperty("user.dir")+"/src/test/resources/images/greentick.png" ;
   
    SpreadsheetMLPackage pkg = SpreadsheetMLPackage.createPackage();
    WorksheetPart worksheet = pkg.createWorksheetPart(new PartName("/xl/worksheets/sheet1.xml"), "Sheet1", 1);

    // Create Drawing part and add to sheet
    Drawing drawingPart = new Drawing();
    Relationship drawingRel = worksheet.addTargetPart(drawingPart);

    // Add anchor XML to worksheet
    org.xlsx4j.sml.CTDrawing drawing = org.xlsx4j.jaxb.Context.getsmlObjectFactory().createCTDrawing();
        worksheet.getJaxbElement().setDrawing(drawing);
            drawing.setId( drawingRel.getId() );    
   
    // Create image part and add to Drawing part
        BinaryPartAbstractImage imagePart
          = BinaryPartAbstractImage.createImagePart(pkg, drawingPart,
View Full Code Here
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
   */
  public WorksheetPart createWorksheetPart(PartName partName,
      String sheetName, long sheetId)
    throws InvalidFormatException, JAXBException {
   
    WorksheetPart worksheetPart = new WorksheetPart(partName);
   
    Relationship r = wb.addTargetPart(worksheetPart);
   
    Sheets sheets = wb.getJaxbElement().getSheets();
   
    Sheet s = Context.getsmlObjectFactory().createSheet();
    s.setName(sheetName);
    s.setId(r.getId());
    s.setSheetId(sheetId);
   
    sheets.getSheet().add(s);
   
    // minimal content for the part
    Worksheet ws = Context.getsmlObjectFactory().createWorksheet();
    worksheetPart.setJaxbElement(ws);
    ws.setSheetData(
        Context.getsmlObjectFactory().createSheetData()
        );
   
    return worksheetPart;
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
              String outputfilepath = System.getProperty("user.dir") + "/OUT_XlsxAddComment.xlsx";

              SpreadsheetMLPackage pkg = SpreadsheetMLPackage.createPackage();

              WorksheetPart sheet = pkg.createWorksheetPart(new PartName("/xl/worksheets/sheet1.xml"), "Sheet1", 1);
              addContent(sheet);

              pkg.save(new File(outputfilepath));

              System.out.println("\n\n done .. " + outputfilepath);  
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
   */
  public static void main(String[] args) throws JAXBException, Docx4JException {
    // TODO Auto-generated method stub
    SpreadsheetMLPackage pkg = SpreadsheetMLPackage.createPackage();
       
    WorksheetPart sheet = pkg.createWorksheetPart(new PartName("/sheet1.xml"), "Sheet1", 1);
         
    CTSheetFormatPr format = Context.getsmlObjectFactory().createCTSheetFormatPr();
    format.setDefaultRowHeight(5);
    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);
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
 
    String outputfilepath = System.getProperty("user.dir") + "/OUT_CreateSimpleSpreadsheet.xlsx";
   
    SpreadsheetMLPackage pkg = SpreadsheetMLPackage.createPackage();
   
    WorksheetPart sheet = pkg.createWorksheetPart(new PartName("/xl/worksheets/sheet1.xml"), "Sheet1", 1);
   
    addContent(sheet);
   
    SaveToZipFile saver = new SaveToZipFile(pkg);
    saver.save(outputfilepath);
View Full Code Here
616
617
618
619
620
621
622
623
624
625
626
            newCell.setR(newRef.toReference());

            newRow.getC().add(newCell);
            newCell.setParent(newRow);

            WorksheetPart worksheetPart = null;
            for (Document.SheetWrapper sheetWrapper : result.getWorksheets()) {
                if (sheetWrapper.getWorksheet().getJaxbElement() == resultWorksheet) {
                    worksheetPart = sheetWrapper.getWorksheet();
                }
            }
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
   
    String outputfilepath = "data/xlsx4j/newWorksheet_Xlsx4j.xlsx";
   
    SpreadsheetMLPackage pkg = SpreadsheetMLPackage.createPackage();
   
    WorksheetPart sheet = pkg.createWorksheetPart(new PartName("/xl/worksheets/sheet1.xml"), "Sheet1", 1);
   
    addContent(sheet);
   
    SaveToZipFile saver = new SaveToZipFile(pkg);
    saver.save(outputfilepath);
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
133
134
    while(it.hasNext()) {
      Map.Entry<PartName, Part> pairs = it.next();
     
      if (partsMap.get(pairs.getKey()) instanceof WorksheetPart) {
       
        WorksheetPart wsp = (WorksheetPart) partsMap.get(pairs.getKey()) ;
       
        List<Row> rows = wsp.getJaxbElement().getSheetData().getRow();

        for (Row row : rows) {
          List<Cell> cells = row.getC();
          for (Cell cell : cells)
          {
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
   
    String outputfilepath = System.getProperty("user.dir") + "/data/xlsx4j/AddImage-Xlsx4j.xlsx";
    String imagefilePath  = System.getProperty("user.dir") + "/data/xlsx4j/greentick.png" ;
   
    SpreadsheetMLPackage pkg = SpreadsheetMLPackage.createPackage();
    WorksheetPart worksheet = pkg.createWorksheetPart(new PartName("/xl/worksheets/sheet1.xml"), "Sheet1", 1);

    // Create Drawing part and add to sheet
    Drawing drawingPart = new Drawing();
    Relationship drawingRel = worksheet.addTargetPart(drawingPart);

    // Add anchor XML to worksheet
    org.xlsx4j.sml.CTDrawing drawing = org.xlsx4j.jaxb.Context.getsmlObjectFactory().createCTDrawing();
        worksheet.getJaxbElement().setDrawing(drawing);
            drawing.setId( drawingRel.getId() );    
   
    // Create image part and add to Drawing part
        BinaryPartAbstractImage imagePart
          = BinaryPartAbstractImage.createImagePart(pkg, drawingPart,
View Full Code Here
TOP

Related Classes of org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart

  • com.haulmont.yarg.formatters.impl.XlsxFormatter
  • org.docx4j.openpackaging.packages.SpreadsheetMLPackage
  • org.docx4j.openpackaging.parts.PartName
  • org.pptx4j.samples.EditEmbeddedCharts
  • org.xlsx4j.samples.CreateSimpleSpreadsheet
  • org.xlsx4j.samples.RowHeight
  • org.xlsx4j.samples.Xlsx4JAddImage
  • org.xlsx4j.samples.XlsxAddComment
  • pptx4j.charts.Pptx4jEditExistingCharts
  • xlsx4j.workingwithworkbook.NewSpreadSheetXlsx4j
    • 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.