如何在 C# 中打开 Excel 文件

Some Important IronXL Features

• Open, read, and search data in different formats (XLS/XLSX file/CSV/TSV).
• Export Excel Worksheets to XLS/XLSX/CSV/TSV/JSON.
• Encrypting and decrypting XLSX/XLSM/XLTX files with passwords.
• Work with Excel sheets as System.Data.DataSet and System.Data.DataTable objects.
• Excel file formulas are recalculated automatically each time a sheet is edited.
• Easy spreadsheet data editing with an intuitive cell-range-based syntax (e.g., WorkSheet["A1:B10"]).
• Sort Cell Ranges, Columns, and Rows.
• Styling Cells - Font, Font Size, Background color, Border, Alignment, and Numbering formats.

Prerequisites

To use IronXL in C# applications, install the following components on your local computer:

1. Visual Studio - It is the official IDE for developing C# .NET applications. You can download and install Visual Studio from the Microsoft website. You can also use Jetbrains ReSharper & Rider.
2. IronXL - It is the Excel library that helps to work with Excel sheets at a given path in C#. It must be installed in your C# application before using it. You can download it from the NuGet website or from Manage NuGet packages in Visual Studio tools. You can also download the .NET Excel DLL file directly.

Adding Necessary Namespaces

Once Visual Studio and IronXL are installed, add the necessary IronXL namespaces by including the following line at the top of your C# file:

// Add reference to the IronXL library
using IronXL;

// Add reference to the IronXL library
using IronXL;

' Add reference to the IronXL library
Imports IronXL

Open an Existing Excel file in C#

Excel files, also known as workbooks, consist of multiple worksheets, each containing cell values. To open and read an Excel file, load it using the WorkBook class's Load method.

// Supported Excel spreadsheet formats for reading include: XLSX, XLS, CSV, and TSV
WorkBook workbook = WorkBook.Load("test.xlsx");

// Supported Excel spreadsheet formats for reading include: XLSX, XLS, CSV, and TSV
WorkBook workbook = WorkBook.Load("test.xlsx");

' Supported Excel spreadsheet formats for reading include: XLSX, XLS, CSV, and TSV
Dim workbook As WorkBook = WorkBook.Load("test.xlsx")

This initializes the workbook as a WorkBook instance. To open a specific WorkSheet, retrieve it from the WorkSheets collection:

// Access the first worksheet in the workbook
WorkSheet sheet = workbook.WorkSheets.First();

// Access the first worksheet in the workbook
WorkSheet sheet = workbook.WorkSheets.First();

' Access the first worksheet in the workbook
Dim sheet As WorkSheet = workbook.WorkSheets.First()

This accesses the first sheet in the Excel file, ready for reading and writing.

Excel File

Read Excel Files in C#

Once the Excel file is opened, it is ready for reading data. Reading data from Excel files in C# using IronXL is straightforward. You can read cell values by specifying the cell reference.

The following code retrieves the value of a cell:

// Select the cell using Excel notation and retrieve its integer value
int cellValue = sheet["C2"].IntValue;

// Display the value in the console
Console.WriteLine(cellValue);

// Select the cell using Excel notation and retrieve its integer value
int cellValue = sheet["C2"].IntValue;

// Display the value in the console
Console.WriteLine(cellValue);

' Select the cell using Excel notation and retrieve its integer value
Dim cellValue As Integer = sheet("C2").IntValue

' Display the value in the console
Console.WriteLine(cellValue)

The output is as follows:

Read Excel

To read data from a range of cells, use a loop to iterate through the specified range:

// Iterate through a range of cells and display their address and text content
foreach (var cell in sheet["A2:A6"])
{
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

// Iterate through a range of cells and display their address and text content
foreach (var cell in sheet["A2:A6"])
{
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

' Iterate through a range of cells and display their address and text content
For Each cell In sheet("A2:A6")
	Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
Next cell

Each value in the cell range A2:A6 is accessed and printed to the console.

Read Range of Cells

For more detailed reading and writing examples, check the Excel reading tutorial in C#.

Create a New Workbook

IronXL also facilitates creating new workbooks for data saving and retrieving.

You can create a new Excel file with a single line of code:

// Create a new workbook with the XLSX format
WorkBook workBook = new WorkBook(ExcelFileFormat.XLSX);

// Create a new workbook with the XLSX format
WorkBook workBook = new WorkBook(ExcelFileFormat.XLSX);

' Create a new workbook with the XLSX format
Dim workBook As New WorkBook(ExcelFileFormat.XLSX)

Next, create a worksheet and add data to it.

Create a New Worksheet

// Create a worksheet named "GDPByCountry" in the workbook
WorkSheet workSheet = workBook.CreateWorkSheet("GDPByCountry");

// Create a worksheet named "GDPByCountry" in the workbook
WorkSheet workSheet = workBook.CreateWorkSheet("GDPByCountry");

' Create a worksheet named "GDPByCountry" in the workbook
Dim workSheet As WorkSheet = workBook.CreateWorkSheet("GDPByCountry")

This code adds a worksheet named "GDPByCountry" to the workbook, allowing you to add cell values.

To set a value for a specific cell, use the code below:

// Set the value of cell A1 to "Example"
workSheet["A1"].Value = "Example";

// Set the value of cell A1 to "Example"
workSheet["A1"].Value = "Example";

' Set the value of cell A1 to "Example"
workSheet("A1").Value = "Example"

The final output is:

Add Value to Cell

Summary

This article demonstrates how to open and read Excel files, such as XLS and XLSX, in C# using IronXL. IronXL doesn't require Microsoft Excel to be installed on the system for Excel-related tasks.

IronXL provides a comprehensive solution for Excel-related tasks programmatically, including formula calculation, string sorting, trimming, finding and replacing, merging and unmerging, saving files, and more. You can also set cell data formats.

IronXL is available for a free 30-day trial and can be licensed for commercial use. IronXL's Lite package starts from $799.