# learn_openpyxl

**Repository Path**: yasenstar/learn_openpyxl

## Basic Information

- **Project Name**: learn_openpyxl
- **Description**: Demo and tutorial on Python's openpyxl library, one-stop site for getting key knowledge
- **Primary Language**: Python
- **License**: GPL-3.0
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-05-08
- **Last Updated**: 2026-05-16

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Mastering Python's `openpyxl`

[![X (formerly Twitter) Follow](https://img.shields.io/twitter/follow/XiaoqiZhao)](https://x.com/XiaoqiZhao)
[![YouTube Channel Subscribers](https://img.shields.io/youtube/channel/subscribers/UCTshmTJGpJunOz23vCEhzWg)](https://www.youtube.com/@yasenzhao)
[![Static Badge](https://img.shields.io/badge/My_LinkedIn--XiaoqiZhao-blue)](https://www.linkedin.com/in/xiaoqi-zhao)

![GitHub Repo stars](https://img.shields.io/github/stars/yasenstar/learn_openpyxl)
![GitHub forks](https://img.shields.io/github/forks/yasenstar/learn_openpyxl)
[![license](https://img.shields.io/pypi/l/spyder.svg)](./LICENSE.txt)
![GitHub language count](https://img.shields.io/github/languages/count/yasenstar/learn_openpyxl)
[![pages-build-deployment](https://github.com/yasenstar/learn_openpyxl/actions/workflows/pages/pages-build-deployment/badge.svg)](https://github.com/yasenstar/learn_openpyxl/actions/workflows/pages/pages-build-deployment)

- [Mastering Python's `openpyxl`](#mastering-pythons-openpyxl)
  - [Purpose](#purpose)
  - [High-Level Structure](#high-level-structure)
  - [Contents](#contents)
  - [Resources about `openpyxl`](#resources-about-openpyxl)
  - [Demo Video Course on Udemy](#demo-video-course-on-udemy)

## Purpose

This course is mainly based on the "Technical Manual" published at https://manuals.muthu.co, and combining several other relevant samples, aiming to provide a **one-stop library** for anyone interested to learn `openpyxl` - Python library - for Microsoft Excel.

## High-Level Structure

![level1-structure](img/openpyxl_level1.png)

You may open the [mindmap file](./Mastering_openpyxl.mm) within the open source tool - FreePlane.

Read the detail structure from the [exported markdown format](./Mastering_openpyxl.md)

## Contents

1. [Introduction](./1_introduction/)
2. [Workbook and Worksheet Objects](./2_workbook_and_worksheet_objects/)
3. [Cells and Cell Values](./3_cells_and_cell_values/)
4. [Styles and Formatting](./4_styles_and_formatting/)
5. [Charts and Graphs](./5_charts_and_graphs/)
6. [Images and Drawings](./6_images_and_drawings/)
7. [Working with Tables](./7_working_with_tables/)
8. [Advanced Features](./8_advanced_features/)
9. [Error Handling and Best Practices](./9_error_heandling/)

## Resources about `openpyxl`

- [OpenPyXL page in gitpages](https://openpyxl.pages.heptapod.net/openpyxl/)
  - [source code](https://foss.heptapod.net/openpyxl/openpyxl)
- [openpyxl 3.1.3 documentation](https://openpyxl.readthedocs.io/en/stable/)
- [Technical Manuals about openpyxl](https://manuals.muthu.co/posts/python-modules/openpyxl.html)
- [A Guide on openpyxl, by Pedro Pregueiro](https://realpython.com/openpyxl-excel-spreadsheets-python/)

## Demo Video Course on Udemy

[![udemy-published-cover](img/udemy_published_cover.png)](https://www.udemy.com/course/mastering-openpyxl-in-python-for-microsoft-excel/?referralCode=26384A8115F94F7B6FC0)

---

Last Updated at 1/1/2026, 9:10:00 AM