Table of Contents

DocWright 1.12

Released 16 November 2026. The headline is Excel: a workbook somebody else made can now be opened, read, changed and saved back with everything else as it was.

Nothing in your code needs to change to move from 1.11: see Upgrading.

Excel workbooks: open, edit, save

DocWright.Formats.Xlsx could write a new workbook. It now also opens an existing .xlsx or .xlsm with XlsxDocument. Charts, pivot tables, tables, comments and macros survive a save, because the file is never rebuilt: only the parts you changed are written again.

New What it does
XlsxDocument.Open, Sheets, Cells, GetCell Read sheets and cells: values, formula text, dates in the workbook's date system, number formats and styles with theme colours resolved.
SetValue, SetFormula, SetStyle, Clear, Remove Change cells in place. The saved workbook asks Excel to recalculate.
SetColumnWidth, SetRowHeight, Merge, Unmerge, Visibility, AddSheet Column widths, row heights, merged ranges, hidden sheets, a new sheet.
FindText, FindRegex, FindWildcards, ReplaceText, ReplaceRegex Search and replace on a sheet or the whole workbook, with the same names and options as a Word document's. Wildcards are Excel's.
FindPlaceholderNames, ReplacePlaceholders Fill {{Name}} markers. A marker that is the whole cell becomes a real number, date or boolean.

Start with the guide Open and edit an existing Excel workbook and the tutorial Generate, export, import and fill Excel files.

Formulas are not calculated by DocWright; a formula cell reads the result Excel last stored.

Word documents

  • Citations and a bibliography, written as Word's References tab writes them. Guide.
  • Cover pages from DocWright's own gallery, placed where Word places one. Guide.
  • Typing into a plain-text content control, with placeholders and controls bound to document properties.
  • Envelopes > Add to Document: an envelope put before the letter, and replaced by Change Document.
  • Pictures: mark a picture decorative; a dragged floating picture is re-anchored as Word re-anchors it. Guide.
  • Equations: conversion between Linear and Professional form as Word converts them, and Math AutoCorrect.
  • Shapes: lines and connectors with Word's arrowheads, dashes and weights; group and ungroup; a group moved, resized and turned as one shape. Guide.

Layout and rendering

  • Text in a turned shape is drawn turned, as Word draws it, including vertical text. Guide.
  • Text wraps around several square-wrapped objects as Word wraps it.

Saving

  • Document defaults are written back as they were read. A document Word wrote with empty default run or paragraph properties keeps them, so a file saved by DocWright opens in Word with the fonts and spacing it had.