Openpyxl Tutorial 

This article is a guide to the best Python Excel library Openpyxl to deal with Excel 2010 xlsx/xlsm files. In this tutorial you will learn how to handle Excel files or spreadsheets in Python using Openpyxl package. You will learn to Read, Write, Create, Load and Manipulate Excel files.

Openpyxl

Openpyxl is a Python library to read, write, modify Excel 2010 or later xlsx/xlsm/xltm/xltx files. Python Programming provides different packages for working with spreadsheets, the most efficient and flexible is this module. Openpyxl works with xlsx file extension and it will not work with earlier versions of excel with xls extension.  

Openpyxl Download

If you want to download openpyxl package on your computer you may use this source. It also provides you information in case if you are not sure which version to choose.

How to Install Openpyxl with pip

If you want to install openpyxl using pip command please use this line of code

$ pip install openpyxl

You may also need to install pillow library in order to add images (jpeg, png, bmp, ...) in your openpyxl file. 

Importing Openpyxl in Python

After successful installation, its time to use openpyxl in python. To call it use import statement like

>>> import openpyxl

or you may need to import only Workbook

>>> from openpyxl import Workbook

Usage Examples

Tutorial

1. Create workbook

2. Add sheet

3. Delete sheet

4. Load workbook

5. Save workbook

6. Close workbook