The Python Excel Library
- Intuitive Python 3+ Excel Document API
- No need to install Microsoft Office or Excel Interop
- Read, edit & create Excel spreadsheet files
- Available in .NET & Python
See what’s new:Changelog
Read Excel Files in Python
See All Code Examplesfrom 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
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
Trusted by millions of engineers worldwide
Ready to Get Started?
Version:2026.9just released


