Zero basic Python office automation of operating Excel_Video Tutorials

零基础Python办公自动化之操作Excel_视频教程

Withdrawal method: Baidu.com
Total [32] sections
Availability of courseware: No

You will gain

Learn how to configure your Python environment

Mastery of basic Python syntax

Learn to work with Excel sheets quickly

No more wasting time doing duplicate work.


population (esp. of a group of people)

Python Programming Practitioner;
Python programming enthusiast;
Python for Beginners;
Python automation domain learners;
Practitioner specializing in Excel reports;
Not a fan of being an office beater who does repetitive labor;
Courses

The content is explained in an easy-to-understand and concise manner, without being wordy or nonsensical.

Getting Started with Python from Scratch
Mastery of basic Python syntax
Detailed explanation and demonstration of how to process Excel with Python



Course Catalog


Chapter 1: Python Environment Configuration
Installing a pristine Python environment 02:03
Downloading and installing PyCharm 03:26

Chapter 2: Python Basics
Variable 01:57
Arithmetic operators 02:48
List 03:52
Tuple 01:57
Dictionary 03:11
Assembly 02:30
if conditional judgment (i) 04:23
if conditional judgment (II) 04:06
while loop 03:12
for loop 02:58

Chapter 3: Python Advanced
Functions (I) 03:07
Functions (II) 04:13
Object-Oriented - Classes (I) 03:16
Object-Oriented - Classes (II) 03:28
Inheritance and polymorphism 05:33
Module 04:28
Standard library and
Third Party Library 05:13
Absolute and relative paths 05:21
File manipulation 05:17
Exception Handling 05:43
Chapter 4: Download Operating Excel
third-party repository
Introduction and installation of the openpyxl library 01:02
Chapter 5: Operating workbooks and worksheets
Opening, creating, saving, and closing workbooks 02:47
A few reasons why errors are reported when opening and saving workbooks 01:42
Opening, new, deleting, and copying worksheets 02:47
Renaming, hiding, and showing worksheets 01:33
Setting up, undoing workbook and worksheet protection 05:12

Chapter 6: Manipulating cell and row data
Reading, modifying, and deleting cell data 04:24
Merging, unmerging, moving cells 04:16
Adding formulas to cells 02:55
Adding pictures to cells 02:23





Resource DownloadThe download price for this resource is17.9Gold coins, please first
Resource Download
Download Prices17.9 gold coin

Resource Disclaimer (Purchase is deemed to be agreement with this statement):
1. Any operation on the website platform is considered to have read and agreed to the registration agreement and disclaimer at the bottom of the website, this site resources have been ultra-low price, and does not provide technical support
2. Some network users share the net disk address may be invalid, such as the occurrence of failure, please send an e-mail to customer service code711cn#qq.com (# replaced by @) will be made up to send
3. This site provides all downloadable resources (software, etc.) site to ensure that no negative changes; but this site can not guarantee the accuracy, security and integrity of the resources, the user downloads at their own discretion, we communicate to learn for the purpose of not all the source code is not 100% error-free or no bugs; you need to have a certain foundation to be able to read and understand the code, be able to modify the debugging yourself! code and solve the error. At the same time, users of this site must understand that the Source Code Convenience Store does not own any rights to the software provided for download, the copyright belongs to the legal owner of the resource.
4. All resources on this site only for learning and research purposes, please must be deleted within 24 hours of the downloaded resources, do not use for commercial purposes, otherwise the legal disputes arising from the site and the publisher of the collateral liability site and will not be borne!
5. Due to the reproducible nature of the resources, once purchased are non-refundable, the recharge balance is also non-refundable

充值送金币,用余额购买,低至6.7折!Recharge Now

Show CAPTCHA
Don't have an account? enrollment  Forgot your password?