1. IronXL for Python
  2. 功能

IronXL for Python Features for C#.NET

This article was translated from English: Does it need improvement?
Translated
View the article in English

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

System.Data Objects

Edit Workbooks

  • Metadata (How-To | Code Example | API Reference)
    • Add, modify, and retrieve granular metadata such as:
    • Author
    • Comments
    • Last printed date
    • Keywords and Category
    • Created and Modified date
    • Subject and Title
    • Retrieve granular metadata such as:
    • Application name
    • Custom properties
    • Company
    • Manager
    • Template
  • Permissions & Passwords (How-To | Code Example | API Reference)
    • Open, edit, and save password-protected spreadsheet.
    • Encrypt Workbook with a password.
  • Create Worksheets (How-To | API Reference)
    • Create a new sheet.
  • Remove Worksheets (How-To | API Reference)
    • Delete an entire sheet.
  • Set Sheet Position (How-To | API Reference)
    • Rearrange the position of sheets.
  • Set Active Tab (How-To | API Reference)
    • 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)
    • Apply and modify formulas without the use of Interop.
  • Recalculation on sheet edit (API Reference)
    • Trigger the recalculation of formulas for the whole spreadsheet.

Data Collection

How-To | Code Example

  • Range (API Reference)
    • Select, edit, and calculate Range in each worksheet.
  • Column (API Reference)
    • Select, edit, and calculate Column in each worksheet.
  • Row (API Reference)
    • Select, edit, and calculate Row in each worksheet.

Create and Edit Charts

  • Area, Bar, Column, Line, Pie, Scatter (Code Example | API Reference)
    • Create Area, Bar, Column, Line, Pie, and Scatter charts with ease.
    • Edit chart configurations such as:
    • Title
    • Legend position

Edit Layout

Edit Worksheets

Cell Ranges

Cell Range Functions

  • Sort (How-To | Code Example | API Reference)
    • Apply ascending or descending sorting to a cell range including a single column and row.
    • Apply sorting based on any particular column in the selected range.
  • Trim (How-To | API Reference)
    • Remove leading and trailing empty cells from the selected range.
  • Clear (How-To | API Reference)
    • Clear the content of a selected cell.
  • Copy (How-To | API Reference)
    • Copy and paste the content and styling of a selected cell to the same or different sheet.
  • Find and Replace (API Reference)
  • Set Hyperlinks (How-To | API Reference)
    • Create 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)
    • Combine multiple adjacent cells into a single, larger cell.
  • Unmerge Cells (How-To | API Reference)
    • Split the merged cell back into its original individual cells.

Style Cells:

Maths Functions:

How-To | Code Example

  • Average (API Reference)
    • Calculate the average of a given range, row, or column.
  • Sum (API Reference)
    • Calculate the total sum of a given range, row, or column.
  • Min (API Reference)
    • Identify the minimum number of a given range, row, or column.
  • Max (API Reference)
    • Identify the maximum number of a given range, row, or column.

Set Cell Data Formats:

How-To | Code Example | API Reference

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