Excel+Python xlwings For Data Analysis and Visualization

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

• Applications, workbooks, worksheets and cell ranges

• Formulas and functions

• Shapes

• Charts

• Pivot Tables

• Conditional Formatting

• ...

xlwings rewraps Win32COM package, supports mixed programming with VBA, and supports data type conversion between various data types.

There are two ways to use xlwings package: new syntax and traditional VBA like syntax. In this course, the first one is called xlwings method, the second one is called API method.

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

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

Formulas and functions can be used with xlwings easily.

And also, xlwings can be used to create many shapes and 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.

xlwings can be used to create and edit pivot tables.

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