ODF Toolkit 範例

ODF範例

public  void main2(String[] args) throws Exception   {
 TextDocument textdoc=(TextDocument)TextDocument.loadDocument("D:/HelloWorld.odt");
 TextNavigation search1;
 search1=new TextNavigation("What",textdoc);
 while (search1.hasNext()) {
  TextSelection item1 = (TextSelection) search1.nextSelection();
  System.out.println(item1);
 }      
 TextNavigation search2 = null;
 search2 = new TextNavigation("What", textdoc);
 while (search2.hasNext()) {
 TextSelection item= (TextSelection) search2.nextSelection();
  item.replaceWith("replacedest");
 }      
 textdoc.save("D:/HelloWorld2.odt");
}

ODS範例

public static void main(String[] args) throws Exception   {
 System.out.println("START");
 SpreadsheetDocument ods = SpreadsheetDocument.newSpreadsheetDocument();
 Table table = Table.newTable(ods, 4000, 20, 0, 0);
 table.setTableName("foo");
 //create style
 OdfOfficeAutomaticStyles astyles = ods.getContentDom().getOrCreateAutomaticStyles();
 StyleStyleElement ele = astyles.newStyleStyleElement(OdfStyleFamily.TableCell.getName(), "myss");
 StyleTableCellPropertiesElement styleTableCellPropertiesElement = ele.newStyleTableCellPropertiesElement();
 styleTableCellPropertiesElement.setFoBackgroundColorAttribute("#A5A5A5");
 styleTableCellPropertiesElement.setFoBorderAttribute("1.0pt solid #000000");
 ele.newStyleParagraphPropertiesElement().setFoTextAlignAttribute(HorizontalAlignmentType.CENTER.toString());
 StyleTextPropertiesElement styleTextPropertiesElement = ele.newStyleTextPropertiesElement(null);
 styleTextPropertiesElement.setStyleFontNameAttribute("Arial");
 styleTextPropertiesElement.setFoFontSizeAttribute("7.0pt");
 styleTextPropertiesElement.setFoColorAttribute(Color.BLACK.toString());
 styleTextPropertiesElement.setFoFontWeightAttribute("bold");

 List rows = table.getRowList();
 for (Row r : rows) {
  for (int a = 0; a < 10; a++) {
   Cell cell = r.getCellByIndex(a);
   cell.setStringValue("Foo " + a);
   cell.setCellStyleName("myss");
  }
 }
 
 ods.save("D:/foo2.ods");
 System.out.println("END");
}

讀檔

SpreadsheetDocument workbook = null;
Cell cell = null;
File tmpFile = new File("tmp.ods")
try {
    workbook = SpreadsheetDocument.loadDocument(tmpFile);
    Table sheet = workbook.getSheetByIndex(0);
    int rows = sheet.getRowCount();
    for (int row = 1;row < rows;row++) {
        String rowStr1 = sheet.getCellByPosition(0, row).getStringValue();
    }
    workbook.close();
} catch (Exception e) {
    e.printStackTrace();
} finally {
    if (workbook != null) {
        workbook.close();
    }
}