Changeset 1208 for trunk/docx4j/src/xlsx4j/java/org/xlsx4j/samples/CreateSimpleSpreadsheet.java

Timestamp:

09/06/10 22:52:07 (21 months ago)

Author:

jharrop

Message:

Some xlsx examples

File:

• trunk/docx4j/src/xlsx4j/java/org/xlsx4j/samples/CreateSimpleSpreadsheet.java (modified) (3 diffs)

trunk/docx4j/src/xlsx4j/java/org/xlsx4j/samples/CreateSimpleSpreadsheet.java

@@ -4 +4 @@
 import org.docx4j.openpackaging.packages.SpreadsheetMLPackage;
 import org.docx4j.openpackaging.parts.PartName;
+import org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart;
+import org.xlsx4j.jaxb.Context;
+import org.xlsx4j.sml.Cell;
+import org.xlsx4j.sml.Row;
+import org.xlsx4j.sml.SheetData;
+import org.xlsx4j.sml.Worksheet;
 
 public class CreateSimpleSpreadsheet {
@@ -13 +19 @@
                 SpreadsheetMLPackage pkg = SpreadsheetMLPackage.createPackage();
                 
-                pkg.createWorksheetPart(new PartName("/xl/worksheets/sheet1.xml"), "Sheet1", 1);
+                WorksheetPart sheet = pkg.createWorksheetPart(new PartName("/xl/worksheets/sheet1.xml"), "Sheet1", 1);
+                
+                addContent(sheet);
                 
                 SaveToZipFile saver = new SaveToZipFile(pkg);
@@ -21 +29 @@
         }
         
+        private static void addContent(WorksheetPart sheet) {
+                
+                // 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);
+                sheetData.getRow().add(row);
+        }
+        
 }