1. IronXL for Python
  2. Features

IronXL for Python Features for C#.NET

IronXL.Excel is a .NET library providing developers with a fast and intuitive way to access, modify, generate Excel and other spreadsheet files in C#.

There is no use of Office Interop and IronXL.Excel works on .NET Core and Azure with no special dependencies or need to install MS Office.

IronXL for Python is a leading .NET Core and .NET Framework Excel spreadsheet library for C# and VB.NET.

Compatibility

.NET Languages

  • C# (Tutorial | API Reference)
    • Read, edit and create spreadsheets in C# with Excel, MVC & ASP.NET
  • VB.NET (Tutorial | API Reference)
    • Read, edit and create spreadsheets in VB.NET with Excel, MVC & ASP.NET
  • F# (API Reference)
    • Read, edit and create spreadsheets in F# with Excel, MVC & ASP.NET

Platforms

  • .NET 5, 6 and 7 (Tutorial | API Reference), .NET Core 2, 3, and 5
    • IronXL for Python is available for .NET 5, 6 and 7.
    • IronXL for Python is also available for .NET Core 2, 3, and 5.
    • The current .NET Core release supports Linux, Unix and macOS client operating systems as well as Mono and Xamarin.
    • A future release will support Xamarin mobile environments.
  • .NET Standard 2 (API Reference)
    • IronXL for Python is compatible with .NET Standard 2.0 and 2.1.
  • .NET Framework 4x (API Reference)
    • Read, edit and create spreadsheet with .NET Framework 4.5 and upwards.

App Types

  • Console, Web, & Desktop (Tutorial | API Reference)
    • Create apps for Console, Web, and Desktop utilizing IronXL for Python.

OS

Create any application using IronXL for Python on Windows, Linux, macOS, Docker, Azure, and AWS

IDEs

Certification

  • Microsoft Authenticode
    • DigiCert Trusted G4 Code Signing RSA4096 SHA384 2021 CA1

Workbooks

Create or Load Spreadsheets

Create How-To | Load How-To | Create Code Example | Load Code Example

  • XLS
    • Create and load .xls file format for Microsoft Excel versions 97-2003.
  • XLSX
    • Create and load .xlsx file format for Microsoft Excel versions 2007 and later.
  • XLTX
    • Load Excel template file in the format of .xltx
  • XLSM
    • Load Excel Macro-Enabled Workbook file in the format of .xlsm
  • CSV
    • Load Comma-Separated Values file in the format of .csv
  • TSV
    • Load Tab-Separated Values file in the format of .tsv

Save or Export Formats

How-To

  • XLS (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_SaveAs_SystemString))
    • Edit, save, and export Microsoft Excel versions 97-2003 in the format of XLS.
  • XLSX, XSLT, XLSM (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_SaveAs_SystemString))
    • Edit and save XLSX, XSLT, XLSM at ease. While exporting spreadsheet to XLSX format.
  • CSV (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_SaveAsCsv_System_String_SystemString))
    • Edit, save, and export CSV file format.
  • TSV (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_SaveAs_SystemString))
    • Edit, save, and export TSV file format.
  • JSON (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_SaveAsJson_SystemString))
    • Edit, save, and export JSON file format.
  • XML (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_SaveAsXml_SystemString))
    • Edit, save, and export XML file format.
  • HTML (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_ExportToHtml_SystemString))
    • Export spreadsheet as HTML file format. Convert workbook into in code HTML string. Options to show or hide properties of Excel when converted to HTML:
    • Column header
    • Hidden columns and rows
    • Leading spaces as non-breaking
    • Row numbers
  • Binary (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_ToBinary))
    • Convert spreadsheet to binary representation.
  • Byte Array (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_ToByteArray))
    • Convert spreadsheet to byte array containing spreadsheet file content.

System.Data Objects

  • DataSet or DataTable (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_ToDataSet_SystemBoolean))
    • Import and export as DataSet or DataTable

Edit Workbooks

  • Metadata (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_Metadata))
    • Add, modify and retrieve granular meta-data such as:
    • Author
    • Comments
    • Last printed date
    • Keywords and Category
    • Created and Modified date
    • Subject and Title
    • Retrieve granular meta-data such as:
    • Application name
    • Custom properties
    • Company
    • Manager
    • Template
  • Permissions & Passwords (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_Encrypt_SystemString))
    • Open, edit and save password protected spreadsheet.
    • Encrypt Workbook with password.
  • Create Worksheets (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_CreateWorkSheet_SystemString))
    • Create a branch new sheet.
  • Remove Worksheets (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_RemoveWorkSheet_SystemInt32))
    • Delete an entire sheet.
  • Set Sheet Position (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_SetSheetPosition_System_String_SystemInt32))
    • Rearrange the position of sheets.
  • Set Active Tab (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_SetActiveTab_SystemInt32))
    • Set the default tab when opening the spreadsheet file in applications like Microsoft Excel.

Worksheets

Edit Formulas

How-To | Code Example

  • Works with Excel formulas ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Formula))
    • Apply and modify formulas without the use of Interop
  • Recalculation on sheet edit ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkBook.html#IronXL for Python_WorkBook_EvaluateAll))
    • Trigger the recalculation of formulas the whole spreadsheet

Data Collection

How-To | Code Example

  • Range ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_Item_SystemString))
    • Select, edit, and calculate Range in each worksheets.
  • Column ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_GetColumns_SystemBoolean))
    • Select, edit, and calculate Column in each worksheets.
  • Row ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_GetRows_SystemBoolean))
    • Select, edit, and calculate Row in each worksheets.

Create and Edit Charts

  • Area, Bar, Column, Line, Pie, Scatter (Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_CreateChart_IronXL for Python_Drawing_Charts_ChartType_System_Int32_System_Int32_System_Int32_SystemInt32))
    • Create Area, Bar, Column, Line, Pie, and Scatter chart at ease
    • Edit chart configuration such as:
    • Title
    • Legend position

Edit Layout

  • Freeze Panes (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_CreateFreezePane_System_Int32_SystemInt32))
    • Create freeze pane of rows and columns allowing them to remain visible while scrolling. These column also called header column or row.
  • Autosize Rows (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_AutoSizeRow_SystemInt32))
    • Automatically adjusts the row size to accommodate the height of the content.
  • Autosize Columns (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_AutoSizeColumn_SystemInt32))
    • Automatically adjusts the column size to accommodate the width of the content.
  • Add Row (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_InsertRow_SystemInt32))
    • Creates and inserts a new row.
  • Add Column (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_InsertColumn_SystemInt32))
    • Creates and inserts a new column.

Edit Worksheets

  • Copy Worksheets (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Copy_IronXL for Python_WorkSheet_SystemString))
    • Duplicate worksheets to keep the original one untouched.
  • Protect with Password (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_ProtectSheet_SystemString))
    • Access and modify protected worksheet without requiring password.
    • Apply password protection to each worksheet individually.
  • Group & Ungroup (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_GroupColumns_System_Int32_SystemInt32))
    • Grouping rows and columns together allows you to hide multiple rows and columns possible.
  • Add Images (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_InsertImage_System_String_System_Int32_System_Int32_System_Int32_SystemInt32))
    • Insert images to worksheet.
  • Remove Images (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_RemoveImage_SystemInt32))
    • Remove images from worksheet.
  • Extract Images (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_Images))
    • Extract images from worksheet.

Cell Ranges

Cell Range Functions

  • Sort (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_SortAscending))
    • Apply ascend or descend sorting to cell range including single column and row.
    • Apply sorting based on any particular column in the selected range.
  • Trim (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Trim))
    • Removes leading and trailing empty cells from the selected range.
  • Clear (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_ClearContents))
    • Clears the content of a selected cell.
  • Copy (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Copy_IronXL for Python_WorkSheet_SystemString))
    • Copies and pastes the content and styling of a selected cell to the same or different sheet.
  • Find and Replace ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Replace_System_String_SystemString))
  • Set Hyperlinks (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Cell.html#IronXL for Python_Cell_Hyperlink))
    • Creates hyperlinks to website URLs, cells, and defined names in the same or different sheet. Also supports opening FTP, files, and email.
  • Merge Cell Ranges (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_Merge_SystemString))
    • Combines multiple adjacent cells into a single, larger cell.
  • Unmerge Cells (How-To | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.WorkSheet.html#IronXL for Python_WorkSheet_Unmerge_SystemInt32))
    • Splits the merged cell back into its original individual cells.

Style Cells:

  • Font and Size (How-To | Code Example)
    • Edit and apply styling to font decoration and size.
  • Border and Alignment (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Formatting.IBorderFormatting.html))
    • Edit and apply styling to border decoration and text alignment.
  • Background pattern (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Formatting.IPatternFormatting.html))
    • Edit and apply background styling without Office Interop.
  • Conditional Formatting (How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Formatting.ConditionalFormatting.html))
    • Edit and apply conditional formatting to cell range.

Maths Functions:

How-To | Code Example

  • Average ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Avg))
    • Calculate average of given range, row, or column.
  • Sum ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Sum))
    • Calculate total sum of given range, row, or column.
  • Min ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Min))
    • Identify minimum number of given range, row, or column.
  • Max ([API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_Max))
    • Identify maximum number of given range, row, or column.

Set Cell Data Formats:

How-To | Code Example | [API Reference](/csharp/excel/object-reference/api/IronXL for Python.Range.html#IronXL for Python_Range_FormatString)

  • Text, Number, Formula, Date, Currency, Scientific, Time, Boolean, Custom Formats
All Available Data Formats