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()

Next Step: Start Free Trial

Fully functional without watermarks

30-day trial - no credit card required

Next Step: Start Free Trial

Fully functional without watermarks

30-day trial - no credit card required

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:

Microsoft Windows
macOS
Linux
Docker
Azure
AWS

IDEs

Jetbrains PyCharm
Other Python IDEs

Workbooks

Create or Load Spreadsheets

XLS
XLSX, XSLT, XLSM
CSV
TSV

Save or Export Formats

XLS
XLSX, XSLT, XLSM
CSV
TSV
JSON
HTML
Binary
Byte Array

Edit Workbooks

Metadata
Permissions & Passwords
Create and Remove Worksheets
Set Sheet Position
Set Active Tab

Worksheets

Edit Formulas:

Works with Excel formulas
Recalculation on sheet edit

Sort Data:

Range
Column
Row

Create and Edit Charts:

Area, Bar, Column, Lines, Pie, Scatter

Edit Layout:

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

Edit Worksheets:

Duplicate Worksheets
Protect with Password
Group and Ungroup
Add, Remove, and Extract Images

Cell Ranges

Cell Range Functions:

Sort
Trim
Clear
Copy
Find and Replace
Set Hyperlinks
Merge and Unmerge Cells

Style Cells:

Font and Size
Border and Alignment
Background Pattern
Conditional Formatting

Maths Functions:

Average and Sum
Min and Max

Set Cell Data Formats:

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

Trusted by millions of engineers worldwide

World-Class Engineering,
24-Hour Support

Talk to an Expert

Ready to Get Started?

Version: 2026.6 just released

Still Scrolling?

Want proof fast?
run a sample watch your data become a spreadsheet.

Try IronXL for Free

Get Set Up in 5 Minutes

Licenses from $749

Iron Support Team

We're online 24 hours, 5 days a week.

Chat

Email

Call Me