Package org.docx4j.openpackaging.packages

Examples of org.docx4j.openpackaging.packages.SpreadsheetMLPackage

822
823
824
825
826
827
828
829
830
831
832
        || pkgContentType.equals(ContentTypes.SPREADSHEETML_WORKBOOK_MACROENABLED)
        || pkgContentType.equals(ContentTypes.SPREADSHEETML_TEMPLATE)
        || pkgContentType.equals(ContentTypes.SPREADSHEETML_TEMPLATE_MACROENABLED) ) {
      //  "xlam", "xlsb" ?
      log.info("Detected SpreadhseetMLPackage package ");
      p = new SpreadsheetMLPackage(this);
      return p;     
    } else if (pkgContentType.equals(ContentTypes.DRAWINGML_DIAGRAM_LAYOUT) ) {
      log.info("Detected Glox file ");
      p = new GloxPackage(this);
      return p;           
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
127
128
      throw new Docx4JException("Could find EmbeddedPackagePart: " + xlsPartName);
    }
   
    InputStream is = BufferUtil.newInputStream(epp.getBuffer());
   
    SpreadsheetMLPackage spreadSheet = (SpreadsheetMLPackage) SpreadsheetMLPackage.load(is);

    Map<PartName,Part> partsMap = spreadSheet.getParts().getParts();    
    Iterator<Entry<PartName, Part>> it = partsMap.entrySet().iterator();

    while(it.hasNext()) {
      Map.Entry<PartName, Part> pairs = it.next();
     
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
  public static void main(String[] args) throws Exception {
 
    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);
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
          try {

              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);  

          } catch (Exception e) {
              e.printStackTrace();
View Full Code Here
20
21
22
23
24
25
26
27
28
29
30
31
32
   * @throws JAXBException
   * @throws Docx4JException
   */
  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);
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
27
28
 
  public static void main(String[] args) throws Exception {
 
    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
21
22
23
24
25
26
27
28
29
30
31
32
33
{
  public static void main(String[] args) throws Exception {
   
    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
112
113
114
115
116
117
118
119
120
121
122
123
124
      throw new Docx4JException("Could find EmbeddedPackagePart: " + xlsPartName);
    }
   
    InputStream is = BufferUtil.newInputStream(epp.getBuffer());
   
    SpreadsheetMLPackage spreadSheet = (SpreadsheetMLPackage) SpreadsheetMLPackage.load(is);

    Map<PartName,Part> partsMap = spreadSheet.getParts().getParts();    
    Iterator<Entry<PartName, Part>> it = partsMap.entrySet().iterator();

    while(it.hasNext()) {
      Map.Entry<PartName, Part> pairs = it.next();
     
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
  public static void main(String[] args) throws Exception {
   
    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);
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
36
37
   * @throws JAXBException
   * @throws Docx4JException
   */
  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);
View Full Code Here
TOP

Related Classes of org.docx4j.openpackaging.packages.SpreadsheetMLPackage

  • org.docx4j.openpackaging.contenttype.ContentType
  • org.docx4j.openpackaging.contenttype.ContentTypeManager
  • org.docx4j.openpackaging.io.SaveToZipFile
  • org.docx4j.openpackaging.parts.PartName
  • org.docx4j.openpackaging.parts.SpreadsheetML.WorkbookPart
  • org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart
  • org.docx4j.relationships.Relationship
  • org.pptx4j.samples.EditEmbeddedCharts
  • org.xlsx4j.samples.CreateSimpleSpreadsheet
  • org.xlsx4j.samples.RowHeight
    • 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.