Materin Office

Read, edit and save Office files directly in Obsidian: .docx, .xlsx, .pptx, .xls, .doc, .ppt.

Part of the Materin plugin series (sibling plugins: materin-ctx, materin-view). 中文说明

Features

• xlsx: Grid editor with cell value editing, formula display, and sheet switching; full style reading.
• xls: Shares the grid editor with xlsx (value-level editing; limited style write-back).
• docx: High-fidelity preview + text-level editing (multi-run text replacement algorithm), preserving 100% of the original formatting.
• pptx: Slide canvas + text box editing; only edited parts are rewritten, all other bytes remain untouched.
• doc: Read-only text extraction (word-extractor); not editable, with one-click open in a system app.
• ppt: Not yet supported; an external-open entry point is planned.
• Safety net: Automatic backup of the original file before first save (can be disabled); external modification conflict detection.

Development

npm install
npm run dev      # watch mode; output is copied into the debug vault
npm run build    # type check + production build
npm run test     # vitest
npm run lint     # eslint (target: 0/0)

Debugging: .debug-vault at the repo root is a symlink to ../debug-vault. A hot-reload plugin is installed in that vault — after npm run dev, open the vault in Obsidian and changes hot-load.

Known Limitations

• xlsx saving rewrites the entire workbook via ExcelJS: charts, images, and pivot caches may be lost (a warning banner appears when opening files that contain them; the first save creates an automatic backup).
• xls (BIFF format) saving keeps cell values only; styles are mostly lost — converting to xlsx is recommended.
• docx/pptx editing is text-level: change text, find & replace; formatting changes (bold, font size, etc.) are not supported.
• The pptx canvas only covers p:sp text shapes: text inside tables/charts is not yet editable; placeholders without a local xfrm inherit geometry from slideLayout (no longer searching slideMaster, so placeholders of some master layouts may fall into the "unpositioned text boxes" area).
• Formulas are recalculated by Excel when the file is opened; this plugin does not recalculate formulas.

License

MIT