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.