如何在 C# 中使用 IronXL 打开 Excel 文件应用程序

Why Choose IronXL Over Microsoft.Office.Interop.Excel?

While Microsoft.Office.Interop.Excel has been the traditional approach for Excel automation, it comes with significant limitations that make IronXL the superior choice for modern applications. Microsoft itself recommends against using Office Interop on servers:

IronXL eliminates the dependency on Microsoft Excel, making it ideal for server environments, Docker containers, and cloud platforms like Azure. The library provides a clean, modern API that eliminates the need for dealing with COM objects or manual memory management.

How to Install IronXL for .NET?

Getting started with IronXL is straightforward; it can be added to your project in minutes. Just install it via the NuGet Package Manager:

Install-Package IronXL.Excel

立即开始使用 IronXL。

免费开始

How to Open and Read Excel Files in C#?

Opening existing Excel files with IronXL requires just a few lines of code. The library supports reading various Excel formats, including XLS and XLSX, as seen in the following code snippet:

// Load an existing Excel file
WorkBook workbook = WorkBook.Load("sales-data.xlsx");
// Access the first worksheet
WorkSheet sheet = workbook.WorkSheets[0];
// Or access a worksheet by name
WorkSheet namedSheet = workbook.GetWorkSheet("January Sales");
// Read a specific cell value
string cellValue = sheet["A1"].StringValue;
Console.WriteLine($"Cell A1 contains: {cellValue}");

// Load an existing Excel file
WorkBook workbook = WorkBook.Load("sales-data.xlsx");
// Access the first worksheet
WorkSheet sheet = workbook.WorkSheets[0];
// Or access a worksheet by name
WorkSheet namedSheet = workbook.GetWorkSheet("January Sales");
// Read a specific cell value
string cellValue = sheet["A1"].StringValue;
Console.WriteLine($"Cell A1 contains: {cellValue}");

IRON VB CONVERTER ERROR developers@ironsoftware.com

The above code demonstrates loading an Excel file into a WorkBook object, which represents the entire Excel file. The WorkBook.Load() method automatically detects the file format (XLS, XLSX, CSV, or TSV) and handles it appropriately.

You can access worksheets either by index or by name using the GetWorkSheet() method. Individual cell values are accessible through intuitive bracket notation, making the code highly readable. For more complex scenarios, explore working with Excel ranges and cell data formats.

How to Create New Excel Workbooks?

Creating new Excel files is equally simple with IronXL's spreadsheet creation capabilities:

// Create a new workbook
WorkBook workbook = WorkBook.Create(ExcelFileFormat.XLSX);
// Add metadata
workbook.Metadata.Author = "Sales Department";
// Create a worksheet
WorkSheet sheet = workbook.CreateWorkSheet("Q1 Report");
// Add data to cells
sheet["A1"].Value = "Product";
sheet["B1"].Value = "Revenue";
sheet["A2"].Value = "Software Licenses";
sheet["B2"].Value = 45000;
// Apply formatting
sheet["B2"].FormatString = "$#,##0.00";
// Save the workbook
workbook.SaveAs("quarterly-report.xlsx");

// Create a new workbook
WorkBook workbook = WorkBook.Create(ExcelFileFormat.XLSX);
// Add metadata
workbook.Metadata.Author = "Sales Department";
// Create a worksheet
WorkSheet sheet = workbook.CreateWorkSheet("Q1 Report");
// Add data to cells
sheet["A1"].Value = "Product";
sheet["B1"].Value = "Revenue";
sheet["A2"].Value = "Software Licenses";
sheet["B2"].Value = 45000;
// Apply formatting
sheet["B2"].FormatString = "$#,##0.00";
// Save the workbook
workbook.SaveAs("quarterly-report.xlsx");

IRON VB CONVERTER ERROR developers@ironsoftware.com

In this code example, the WorkBook.Create() method initializes a new workbook with your specified format. You can add multiple worksheets using CreateWorkSheet(), populate specific cells in your Excel's rows and columns with various data types, and apply formatting styles. The library automatically handles data type conversion and Excel-specific formatting requirements. Learn more about Excel formulas in C# for advanced calculations.

How to Read and Process Excel Worksheet Data?

IronXL excels at data extraction and processing:

// Load workbook
WorkBook workbook = WorkBook.Load("inventory.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Read a range of cells
var range = sheet["A1:D5"];
foreach (var cell in range)
{
    Console.WriteLine($"{cell.AddressString}: {cell.Text}");
}
// Convert to DataTable for easier processing
System.Data.DataTable dataTable = sheet.ToDataTable(true);
// Process data using LINQ
decimal total = sheet["C2:C5"].Sum();
Console.WriteLine($"Total: {total}");

// Load workbook
WorkBook workbook = WorkBook.Load("inventory.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Read a range of cells
var range = sheet["A1:D5"];
foreach (var cell in range)
{
    Console.WriteLine($"{cell.AddressString}: {cell.Text}");
}
// Convert to DataTable for easier processing
System.Data.DataTable dataTable = sheet.ToDataTable(true);
// Process data using LINQ
decimal total = sheet["C2:C5"].Sum();
Console.WriteLine($"Total: {total}");

IRON VB CONVERTER ERROR developers@ironsoftware.com

Here, we use the same process to open our Excel file in the project. The range selection syntax (sheet["A1:D5"]) provides an elegant way to work with multiple cells. The ToDataTable() method converts worksheet data into a DataTable, enabling integration with databases and data-binding scenarios. IronXL also supports aggregate functions, such as Sum(), Average(), and Max(), directly on ranges. For handling larger datasets, see the complete API documentation.

Working Without Microsoft Office

One of IronXL's greatest strengths is its ability to operate independently of Microsoft Office. This capability opens up numerous deployment scenarios:

• Cloud Deployment: Run on Azure, AWS, or Google Cloud without licensing concerns
• Docker Containers: Include in containerized applications without complex Office installations
• Linux Servers: Deploy to cost-effective Linux environments
• CI/CD Pipelines: Generate Excel reports in automated build processes

The library handles all Excel file generation and manipulation internally, utilizing its own rendering engine to ensure consistent results across all platforms.

Conclusion

IronXL offers a modern and efficient solution for opening and manipulating Excel files in C#. By eliminating Excel dependencies and offering a clean API, it simplifies development while enabling broader deployment options. Whether you're building desktop applications, web services, or cloud-based solutions, IronXL ensures your Excel automation works reliably across all environments.

Ready to modernize your Excel automation? Download IronXL for a free trial starting at $liteLicense.