IronXL for Python via .NET

Read, edit and create Excel spreadsheet files with no need for Microsoft Office or Excel Interop.

Published by Iron Software
Distributed by ComponentSource since 2017

Prices from: ￦ 1,034,500 Version: 2025.x NEW Updated: May 10, 2025

Screenshot of IronXL for Python via .NET

About IronXL for Python via .NET

Read, edit and create Excel spreadsheet files with no need for Microsoft Office or Excel Interop.

IronXL for Python via .NET is a Python Excel library for generating and editing Excel documents. You can read and edit XLS/XLSX/CSV/TSV and save an export to XLS/XLSX/CSV/TSV/JSON. Its user friendly API allows developers to add Excel functionality to Python projects in minutes.

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