[GET] Automating Excel with Python

Automating Excel with Python, the video course, will help you learn how to read and write Microsoft Excel spreadsheets with the Python programming language.

In this course and the companion book, you will learn about the following:

Opening and Saving Workbooks

Reading Cells and Sheets

Creating a Spreadsheet (adding/deleting rows and sheets, merging cells, folding, freeze panes)

Cell Styling (font, alignment, side, border, images)

Conditional Formatting

Charts

and more!

Python is a great language that you can use to enhance your daily work, whether you are an experienced developer or a beginner!

7 Likes

The problem is that openpyxl doesn’t support newest versions of Excel. In its documentation is written that it supports Excel 2010, however it works also with 2013. I haven’t seen a free python library which works with Excel 202x.