IRONSOFTWAREHOME
IronXL for Python Excel Spreadsheet Library for Python

The Python Excel Library

  1. Intuitive Python 3+ Excel Document API
  2. No need to install Microsoft Office or Excel Interop
  3. Read, edit & create Excel spreadsheet files
  4. Available in .NET & Python

See what’s new:Changelog
Read Excel Files in Python
See All 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 C#, F#, & VB.NET running on .NET 10, 9, 8, 7, 6, 5, Core, Standard, or Framework

NET Logo
Visual Studio Logo
NuGet Logo
ReSharper
Windows Logo
Linux Logo
Mac Logo
Docker Logo
Azure Logo
AWS Logo

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.

Get your free 30-day Trial Key instantly.

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
  • 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

World-Class Engineering,
24-Hour Support

Ready to Get Started?

Version:2026.9just released

Get your free 30-day Trial Key instantly.
No credit card or account creation required
Key in blue circle

Get your free 30-day Trial Key instantly.

Your trial license will be sent to your email address

No limitations. 100% unlocked. No credit card.

bullet_checkedNo credit card or account creation requiredNo limitations. 100% unlocked. No credit card.
  • Logo Aetna
  • Logo NASA
  • Logo GE
  • Logo Porsche
  • Logo USDA
  • Logo Qatar
Join Millions of Engineers who’ve tried IronPDF
Book your free Live Demo
Booking Badge

Trusted by Millions of Engineers Worldwide

Iron Software's customer logos
Get Your No-Obligation Consult
Complete the form below or email sales@ironsoftware.com
Your details will always be kept confidential.
Trusted by Millions of Engineers Worldwide
Iron Software's customer logos
Get your free 30-day Trial Key instantly.
No credit card or account creation required