import org.odftoolkit.odfdom.doc.OdfSpreadsheetDocument; //导入依赖的package包/类
public static File layoutGeneratedOdsFile(File generatedOdsFile) {
    File odsOutFile = new File(System.getProperty("java.io.tmpdir") + File.separator + "Layouted_" + generatedOdsFile.getName());

    try {
        OdfSpreadsheetDocument spreadsheet = OdfSpreadsheetDocument.loadDocument(generatedOdsFile);

        List<OdfTable> tableList = spreadsheet.getTableList();
        for (OdfTable table : tableList) {
            table = formatCategories(table);
            table = formatNodes(table);
        }
        spreadsheet.save(odsOutFile);
    } catch (Exception ex) {
        logger.error("Layouting of the OdsFile went wrong.", ex);
    }
    return odsOutFile;
}
 

import org.odftoolkit.odfdom.doc.OdfSpreadsheetDocument; //导入依赖的package包/类
public Collection<NodeToCategoryMapping> getNodeToCategoryMappingsFromFile() {
    Map<String, NodeToCategoryMapping> nodesToCategories = new HashMap<>();

    try {
        OdfSpreadsheetDocument spreadsheet = OdfSpreadsheetDocument.loadDocument(this.m_odsFile);

        for (OdfTable table : spreadsheet.getTableList()) {
            nodesToCategories = getNodeToCategoryMappingsFromTable(nodesToCategories, table);
        }

    } catch (Exception ex) {
        logger.error("Reading spreadsheet went wrong", ex);
    }

    return nodesToCategories.values();
}
 

import org.odftoolkit.odfdom.doc.OdfSpreadsheetDocument; //导入依赖的package包/类
void setupOutputDocument() {
	try {
		outputDocument = OdfSpreadsheetDocument.newSpreadsheetDocument();
		contentDom = outputDocument.getContentDom();
		stylesDom = outputDocument.getStylesDom();
		contentAutoStyles = contentDom.getOrCreateAutomaticStyles();
		stylesOfficeStyles = outputDocument.getOrCreateDocumentStyles();
		officeSpreadsheet = outputDocument.getContentRoot();
	} catch (Exception e) {
		System.err.println("Unable to create output file.");
		System.err.println(e.getMessage());
		outputDocument = null;
	}
}
 

import org.odftoolkit.odfdom.doc.OdfSpreadsheetDocument; //导入依赖的package包/类
public OdfWorkbook(String filename, String encoding) throws KettleException {
  this.filename = filename;
  this.encoding = encoding;
  
  try {
    document = OdfSpreadsheetDocument.loadDocument(KettleVFS.getInputStream(filename));
  } catch(Exception e) {
    throw new KettleException(e);
  }
}
 

import org.odftoolkit.odfdom.doc.OdfSpreadsheetDocument; //导入依赖的package包/类
public OdfWorkbook( String filename, String encoding ) throws KettleException {
  this.filename = filename;
  this.encoding = encoding;

  try {
    document = OdfSpreadsheetDocument.loadDocument( KettleVFS.getInputStream( filename ) );
  } catch ( Exception e ) {
    throw new KettleException( e );
  }
}