Excel+Python OpenPyXL For Data Analysis and Visualization

This course will teach you many things about OpenPyXL that the website of OpenPyXL, Google and ChatGPT can't tell you.

• Applications, workbooks, worksheets and cell ranges

• Formulas and functions

• Charts

• Pivot Tables

• Conditional Formatting

• ...

OpenPyXL does not rely on Excel, suitable for software development. Lightweight and flexible, supports object models, powerful functionality, cross-platform..

The general process of using OpenPyXL includes three steps: import OpenPyXL package, data processing and quit the application.

In OpenPyXL object model, the main objects include Workbook, Worksheet and Range, many related operations introduced in the course.

Formulas and functions can be used with OpenPyXL easily. You can input general formulas and array formulas in the worksheet, most of the worksheet functions can be used in the forumlas.

And also, OpenPyXL can be used to create many different types of charts in Excel worksheet. Please note that, these charts are created by Excel graphing engine, but not Matplotlib graphing engine, so, these charts can be editted easily by Excel.

OpenPyXL can be used to refresh and edit existing pivot tables. Few people know these operations, and also Google and ChatGPT.

OpenPyXL can also be used to create and edit conditional formattings such as data bars, color scales, icon sets, etc.