Office Automation

Excel, Word and PowerPoint files.

Easy

This is an overview — pick a sub-topic below.

Sub-topics (5)

Read/write Excel .xlsx (openpyxl), create rich spreadsheets with charts (XlsxWriter), and read old .xls (xlrd) and binary .xlsb (pyxlsb).

Beginner♥ 0🔖 0💬 0

Control a running Excel from Python and call Python from Excel.

Easy♥ 0🔖 0💬 0

Create and edit Word documents; fill .docx templates with Jinja2 placeholders (docxtpl).

Beginner♥ 0🔖 0💬 0

Build PowerPoint presentations programmatically — slides, text, tables, charts and images.

Easy♥ 0🔖 0💬 0

Automate Windows Office apps via COM (pywin32), and Docs/Sheets/Drive via Google APIs (gspread for Sheets).

Intermediate♥ 0🔖 0💬 0

Spotted a mistake or want to add detail? Suggest an improvement — Content Contributors' edits are reviewed by editors before they go live.