Automation Libraries for Office Suite
WorkBuddy executes local Python environments to edit documents programmatically. The recommended libraries:
- Word (
python-docx): Reads paragraphs, replaces placeholders, edits tables, and applies formatting styles. - Excel (
openpyxl): Handles cell reading/writing, inserts formulas, executes data filters, and builds pivot tables. - PowerPoint (
python-pptx): Compiles slides, inserts text blocks, and applies custom layouts based on structured model text.
| Tool | Library | Operations |
|---|---|---|
| Word | python-docx | Replace paragraph text, modify tables, generate documents |
| Excel | openpyxl | Write records, compute ledger cells, append sheets |
| PowerPoint | python-pptx | Render slide decks, map outline layouts |
References
Part of this series
WorkBuddy In Action
View all guides in this series →