The Python Excel Library

Read Excel Files in Python See All 25 Code Examples

from ironxl import *

# Supported for XLSX, XLS, XLSM, XLTX, CSV, and TSV
workbook = WorkBook.Load("sample.xlsx")

# Select worksheet at index 0
worksheet = workbook.WorkSheets[0]

# Get any existing worksheet
first_sheet = workbook.DefaultWorkSheet

# Select a cell and return the converted value
cell_value = worksheet["A2"].IntValue

# Read from ranges of cells elegantly.
for cell in worksheet["A2:A10"]:
    print("Cell {} has value '{}'".format(cell.AddressString, cell.Text))

# Calculate aggregate values such as Min, and Sum
total_sum = worksheet["A2:A10"].Sum()

Explore the code, install IronXL for Python with PyPI

Cross Platform Support

Designed for Python 3+ running on Windows, Mac, Linux or Cloud Platforms.
Available for .NET & Python

A Python Excel Library that prioritizes accuracy and ease of use.

IronXL for Python is the leading Python Excel library for generating and editing Excel documents. Its user friendly API allows developers to add Excel functionality to Python projects in minutes.

The C# Excel Library

Get your free 30-day Trial Key instantly.

badge_greencheck_in_yellowcircle

Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com

The Excel API you need, without the Office Interop hassle.

Compatibility

.Platforms:

Python 3.7+

OS:

IDEs

Workbooks

Create or Load Spreadsheets

Save or Export Formats

Edit Workbooks

Worksheets

Edit Formulas:

Sort Data:

Create and Edit Charts:

Area, Bar, Column, Lines, Pie, Scatter

Edit Layout:

Freeze Panes
Autosize Rows/Columns
Add and Remove Rows/Columns

Edit Worksheets:

Cell Ranges

Cell Range Functions:

Style Cells:

Maths Functions:

Average and Sum
Min and Max

Set Cell Data Formats:

Text, Number, Formula, Date, Currency, Scientific, Time, Boolean, Custom Formats

View Full Features Set

Trusted by over 2 million engineers worldwide

World-Class Engineering,
24-Hour Support

Talk to an Expert

Ready to Get Started?

Version: 2025.9 just released

Try IronXL for Free

Get Set Up in 5 Minutes

Licenses from $749