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