Skip to content

openpyxl python

openpyxl is a Python library to read and write Excel 2010 xlsx/xlsm/xltx/xltm files. It was born from lack of existing library to read/write natively from Python the Office Open XML format. All kudos to the PHPExcel team as openpyxl was initially based on PHPExcel.

openpyxl is a powerful tool for working with Excel files in Python. It can be used to perform a wide range of tasks, including:

  • Reading and writing Excel data
  • Creating and formatting worksheets
  • Inserting and deleting rows and columns
  • Merging and splitting cells
  • Applying cell styles
  • Creating charts and graphs
  • Protecting worksheets and workbooks

openpyxl is easy to use and has a well-documented API. It is also actively maintained and updated with new features and bug fixes regularly.

Here is a simple example of how to use openpyxl to read and write Excel data:


import openpyxl

# Open the Excel file
wb = openpyxl.load_workbook('my_excel_file.xlsx')

# Get the active worksheet
ws =

# Read the value of cell A1
cell_value = ws['A1'].value

# Write the value of cell A1
ws['A1'].value = 'Hello, world!'

# Save the Excel file'my_excel_file.xlsx')

This is just a simple example, but openpyxl can be used to perform much more complex tasks. For more information, please see the openpyxl documentation:

If you have any specific questions about using openpyxl, please feel free to ask.

Leave a Reply

Your email address will not be published. Required fields are marked *


Enjoy this blog? Please spread the word :)