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 MS Office and PDF document structure
Learn Python programming by doing in Office context
Requirements:
No specific prerequisit
Description:
Refer 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.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
Homepage