编程语言
Python、C、C++、Java、JavaScript、TypeScript、Go、R 与 Haskell 教程,从入门语法到高级技巧。
Session 1 Exercises
Complete these exercises to reinforce your understanding of Python Excel basics.
阅读文章 →Session 2: Reading Excel Files - Comprehensive Guide
Reading Excel files effectively is the foundation of Excel automation. This session covers all the techniques you need to read Excel files with various structures, handle different data types, and extract exactly the dat
阅读文章 →Session 2: Reading Excel Files
Master comprehensive techniques for reading Excel files with various structures and formats.
阅读文章 →Session 3: Writing Excel Files - Comprehensive Guide
Writing Excel files is as important as reading them. In this session, you'll learn how to create Excel files from scratch, write DataFrames to Excel, format outputs, and handle multiple sheets. You'll also learn performa
阅读文章 →Session 3: Writing Excel Files
Learn comprehensive techniques for creating and writing Excel files with Python.
阅读文章 →Session 4: Data Manipulation with Pandas - Comprehensive Guide
Data manipulation is the heart of working with Excel files in Python. Real-world Excel data is rarely perfect - it has missing values, duplicates, inconsistent formatting, and requires transformation before analysis. Thi
阅读文章 →Session 4: Data Manipulation with Pandas
Master advanced data manipulation techniques for processing Excel data.
阅读文章 →Session 5: Excel Formatting and Styling - Comprehensive Guide
Creating professional-looking Excel reports is essential for presenting data effectively. This session teaches you how to format Excel files with colors, fonts, borders, number formats, and conditional formatting to crea
阅读文章 →Session 5: Excel Formatting and Styling
Create professional-looking Excel reports with formatting and styling.
阅读文章 →Session 6: Working with Formulas and Charts - Comprehensive Guide
Excel formulas and charts are essential for creating dynamic, interactive reports. This session teaches you how to write Excel formulas from Python and create professional charts that visualize your data effectively.
阅读文章 →Session 6: Working with Formulas and Charts
Add Excel formulas and create charts programmatically.
阅读文章 →Session 7: Merging and Combining Excel Files - Comprehensive Guide
One of the most powerful features of Python Excel automation is the ability to merge and consolidate data from multiple Excel files. This session teaches you how to combine files vertically and horizontally, handle diffe
阅读文章 →Session 7: Merging and Combining Excel Files
Master techniques for consolidating data from multiple Excel files.
阅读文章 →Session 8: Advanced Data Operations - Comprehensive Guide
This session covers advanced Excel operations that take your automation to the next level: named ranges, data validation, worksheet protection, Excel tables, freeze panes, and advanced filtering techniques.
阅读文章 →Session 8: Advanced Data Operations
Explore advanced Excel features including named ranges, data validation, and protection.
阅读文章 →Session 9: Working with Large Excel Files - Comprehensive Guide
Large Excel files (10MB+, 100K+ rows) require special techniques to handle efficiently. This session teaches you memory-efficient reading, chunking, streaming, optimization, and best practices for production environments
阅读文章 →Session 9: Working with Large Excel Files
Master techniques for handling large Excel files efficiently.
阅读文章 →Session 10: Automation and Batch Processing - Comprehensive Guide
Automation transforms manual, repetitive Excel tasks into efficient, error-free workflows. This session teaches you how to process multiple files in batches, create automated workflows, schedule report generation, and bu
阅读文章 →Session 10: Automation and Batch Processing
Build robust automation workflows for Excel processing.
阅读文章 →Session 11: Advanced Excel Features - Comprehensive Guide
This final advanced session covers specialized Excel features: working with macros, inserting images, managing hyperlinks, adding comments, working with metadata, and integrating with other file formats like CSV, JSON, a
阅读文章 →Session 11: Advanced Excel Features
Explore advanced Excel features including macros, images, and multi-format integration.
阅读文章 →Session 12: Real-World Projects and Best Practices
This final session brings together everything you've learned to build complete, production-ready Excel automation projects. You'll learn best practices, design patterns, and how to create robust, maintainable Excel autom
阅读文章 →Session 12: Real-World Projects and Best Practices
Apply all your knowledge in comprehensive real-world projects.
阅读文章 →Python Qt GUI Development - Complete Learning Guide
Welcome to the comprehensive guide for building desktop applications with Python using Qt frameworks. This repository contains complete teaching materials covering PySide6 and PyQt6 from beginner to advanced levels.
阅读文章 →