Withdrawal method: Baidu.comTotal [32] sectionsAvailability of courseware: NoYou 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 andThird Party Library 05:13 Absolute and relative paths 05:21 File manipulation 05:17 Exception Handling 05:43 Chapter 4: Download Operating Excelthird-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 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