Put Word, Excel, and PowerPoint Files to Work in Your Own Apps and Systems

Swift

try SDKLicense.activate(key: licence)

var scene = try DocumentParser.parse(
    docxAt: template)
for (placeholder, value) in values {
    scene = WordSceneEditor.replaceAll(
        placeholder, with: value, in: scene,
        caseSensitive: true).scene
}
try DocumentWriter.save(
    document: scene, originalURL: template,
    destinationURL: output)

Swift

try SDKLicense.activate(key: licence)

var book = try SpreadsheetParser.parse(
    xlsxAt: quote, rasterizer: nil)
book = WorkbookSceneEditor.settingCellValue(
    .number(25), formula: nil, at: quantity,
    sheetIndex: 0, in: book)!
// A cached result is never recomputed, so
// clear each formula's, then evaluate them.
let formulas = book.sheets[0].cells.filter {
    $0.formula != nil }
for cell in formulas {
    book = WorkbookSceneEditor.settingCellValue(
        .empty, formula: cell.formula,
        at: cell.reference, sheetIndex: 0,
        in: book)!
}
let context = SceneWorkbookContext(
    scene: book, homeSheetIndex: 0)
for cell in formulas {
    let value = Formula.evaluate(
        cell.formula!, in: context)
    book = WorkbookSceneEditor.settingCellValue(
        value, formula: cell.formula,
        at: cell.reference, sheetIndex: 0,
        in: book)!
}
try SpreadsheetWriter.save(
    workbook: book, originalURL: quote,
    destinationURL: output)