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.