The Boring Python Office Talk - Automate Powerpoint, Excel, and PDF with Python

Discover how to automate mundane office tasks using Python in this 28-minute EuroPython Conference talk. Learn to manipulate DOCX, XLSX, PPTX, and PDF files efficiently, creating Excel reports, PowerPoint presentations, and PDF documents with ease. Follow the contrasting experiences of Bob, who performs tasks manually, and Ann, who leverages Python's powerful libraries for automation. Gain insights into loading input files, data transformation, pivoting, exporting to Excel, customizing formats, creating charts, and working with PowerPoint slides. Explore techniques for combining PDF files and converting presentations to PDF using LibreOffice CLI. By the end of this talk, acquire the knowledge to streamline your daily office routines and boost productivity through Python-driven automation.

Syllabus

Intro
Motivation
The Challenge
What you should get from this Talk
Things we want Python to do.
Modules Used
Overall Program Flow
Excel and Python
Loading the Input Files
Data Transformation and Pivots
Simple Export to Excel
Adding an Introduction Sheet
Custom Formats by Hand (1/2)
Tables & Conditional Formats (1/2)
Creating Charts (1/2)
So much for Excel
Powerpoints with PPTX
Adding Text Boxes and Graphics
Adding Table Data to a Slide
Adding Charts to a Slide (1/2)
PPTX to PDF with Libreoffice CLI
Combining PDF Files