When Python Meets Office (Excel, Word, Powerpoint, Pdf)
Published 3/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English
| Duration: 3h 30m
Use Python to achieve office automation in MS Office as well as PDF format documents
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!
Overview
Section 1: 介绍
Lecture 1 介绍
Section 2: Python Basics - Data Structure
Lecture 2 Python Data Structure - Numeric Type
Lecture 3 Python Data Structure - String Type
Lecture 4 Python Data Structure - List
Lecture 5 Python Data Structure - Tuple
Lecture 6 Python Data Structure - Dictionary
Lecture 7 Python Data Structure - Set and None Type (part 1)
Lecture 8 Python Data Structure - Set and None Type (part 2)
Lecture 9 Python Data Structure - Changeable and Non-Changeable Data Types
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
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Free search engine download: When Python Meets Office (Excel, Word, PowerPoint, PDF)