Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Use Python for Office (Excel, Word, PowerPoint, PDF)
Rating: 4.7 out of 5(5 ratings)
154 students

Use Python for Office (Excel, Word, PowerPoint, PDF)

Use Python to achieve office automation in MS Office as well as PDF format documents
Created byXiaoqi Zhao
Last updated 3/2025
English

What you'll learn

  • How to achieve office automation through Python
  • Learn relevant Python library - openpyxl, python-docx, python-pptx and pypdf2
  • Step by step breakdown and demo on all of those Microsoft (MS) Office and PDF document structure
  • Learn Python programming by doing in Office context

Course content

10 sections91 lectures33h 49m total length
  • 介绍25:16

Requirements

  • No specific prerequisit

Description

This is the self learning the book (in Chinese) 《让Python遇上Office - 从编程入门到自动化办公实践》"When Python Meets Office - From Entry Programming to Office Automation Practice", teach in English language, let you familiar the related Python library dealing with Excel (openpyxl), Word (python-docx), PowerPoint (python-pptx) and PDF (pypdf2 or pypdf3), demo and guide you not only the usage of those libraries, but also practice the actual exercise in those variable office components.

You can buy this book either from online store or read directly from WeChat Read app.

After the course, you'll be confidently choose the right "tool" in proper scenario, and improve your office automation productivity.

The book has 10 chapters in total, divided into 3 parts: The first part (Chapter 1~5) includes the basic knowledge of getting started with Python from scratch (data types, functions, classes and objects, catching exceptions, file operations, management modules, etc.); Chapter 1 The second part (Chapter 6~9) focuses on operating office documents and introduces how to use Python code to process Word, Excel, PPT, and PDF documents to realize document office automation; the third part (Chapter 10) is the advanced part. It involves desktop automation, sending emails, network requests, scheduled tasks, GUI, packaging programs, etc., which can help readers further improve work efficiency.

The course is focusing on show you how to learn by doing! I do hope you can learn new skills as well as feel fun during the journey! Good luck!

Who this course is for:

  • Students or teacher who are willing to learn Python language
  • Office workers who are willing to learn Python and apply Python to office automation
  • Starter with zero basis on Python but want to learn the language