如何在 C# 控制台应用程序中读取 Excel 文件

How to Read an Excel File in a C# Console Application

1. Create a C# Console Application in Visual Studio
2. Install the IronXL C# Excel Library
3. Create a Workbook class Object
4. Load the Excel file using Workbook.Load method
5. Load the Worksheet using the WorkSheets method
6. Read the Excel File data using WorkSheet.Row method
7. Loop through the Cell values
8. Print the Cell.Text on Console Window

Introduction to IronXL Library

IronXL is a .NET library designed to simplify Excel-related tasks for developers. Whether you need to create, modify, or read Excel files, IronXL offers a comprehensive set of features and functionalities. IronXL simplifies the process of interacting with Excel workbooks, sheets, and cells.

With IronXL, developers can effortlessly read and write data to Excel files, enabling seamless integration of Excel functionality into C# projects without Microsoft Office Interop or Excel installed.

By leveraging the capabilities of IronXL, developers can manipulate cell values, extract data from an Excel Workbook, and generate Excel documents dynamically. With its intuitive API and robust feature set, IronXL empowers developers to efficiently handle Excel data, making tasks such as data analysis, reporting, and document generation a breeze.

Whether you're working with Microsoft Excel files, spreadsheets, or worksheets, IronXL provides the tools you need to streamline your C# application development process.

Creating Console Application using Visual Studio

Let's start by creating a new C# Console Application in Visual Studio.

1. Open Visual Studio.
2. Select "Create a New Project".

3. Choose "Console App" under C# templates.

4. Provide a name for your project and click "Next."

5. Set the appropriate .NET Framework and click "Create."

Install IronXL using the NuGet Package Manager Console or Solutions

Now that we have our console application, we need to install the IronXL library.

Install-Package IronXL.Excel

Steps to Read Excel Files using IronXL

Now, let's go through the steps to read an Excel file using IronXL in our C# Console Application. The following code snippet allows you to read Excel files in the C# console application:

using IronXL;

class Program
{
    public static void Main()
    {
        // Specify the path to the Excel file
        string excelFilePath = "path/to/your/excel/file.xlsx";

        // Create a WorkBook object by loading an existing Excel file
        WorkBook workBook = WorkBook.Load(excelFilePath);

        // Access the first worksheet in the workbook
        WorkSheet workSheet = workBook.WorkSheets[0];

        // Iterate through each row in the worksheet
        foreach (var row in workSheet.Rows)
        {
            // Iterate through each cell in the row
            foreach (var cell in row)
            {
                // Print the text of the cell followed by a tab
                Console.Write(cell.Text + "\t");
            }
            // Move to the next line after each row
            Console.WriteLine();
        }

        // Close the workbook to free resources
        workBook.Close();
    }
}

using IronXL;

class Program
{
    public static void Main()
    {
        // Specify the path to the Excel file
        string excelFilePath = "path/to/your/excel/file.xlsx";

        // Create a WorkBook object by loading an existing Excel file
        WorkBook workBook = WorkBook.Load(excelFilePath);

        // Access the first worksheet in the workbook
        WorkSheet workSheet = workBook.WorkSheets[0];

        // Iterate through each row in the worksheet
        foreach (var row in workSheet.Rows)
        {
            // Iterate through each cell in the row
            foreach (var cell in row)
            {
                // Print the text of the cell followed by a tab
                Console.Write(cell.Text + "\t");
            }
            // Move to the next line after each row
            Console.WriteLine();
        }

        // Close the workbook to free resources
        workBook.Close();
    }
}

Imports Microsoft.VisualBasic
Imports IronXL

Friend Class Program
	Public Shared Sub Main()
		' Specify the path to the Excel file
		Dim excelFilePath As String = "path/to/your/excel/file.xlsx"

		' Create a WorkBook object by loading an existing Excel file
		Dim workBook As WorkBook = WorkBook.Load(excelFilePath)

		' Access the first worksheet in the workbook
		Dim workSheet As WorkSheet = workBook.WorkSheets(0)

		' Iterate through each row in the worksheet
		For Each row In workSheet.Rows
			' Iterate through each cell in the row
			For Each cell In row
				' Print the text of the cell followed by a tab
				Console.Write(cell.Text & vbTab)
			Next cell
			' Move to the next line after each row
			Console.WriteLine()
		Next row

		' Close the workbook to free resources
		workBook.Close()
	End Sub
End Class

This C# code snippet demonstrates how to use the IronXL library to read data from an Excel file and display it in a console application. The following Excel file will be read and displayed on the console window:

Now, let's break down the code step by step:

using IronXL;

using IronXL;

Imports IronXL

public static void Main() {
    // Main method where the program execution begins 
}

public static void Main() {
    // Main method where the program execution begins 
}

Public Shared Sub Main()
	' Main method where the program execution begins 
End Sub

string excelFilePath = "path/to/your/excel/file.xlsx";

string excelFilePath = "path/to/your/excel/file.xlsx";

Dim excelFilePath As String = "path/to/your/excel/file.xlsx"

WorkBook workBook = WorkBook.Load(excelFilePath);

WorkBook workBook = WorkBook.Load(excelFilePath);

Dim workBook As WorkBook = WorkBook.Load(excelFilePath)

WorkSheet workSheet = workBook.WorkSheets[0];

WorkSheet workSheet = workBook.WorkSheets[0];

Dim workSheet As WorkSheet = workBook.WorkSheets(0)

foreach (var row in workSheet.Rows)
{
    foreach (var cell in row)
    {
        Console.Write(cell.Text + "\t");
    }
    Console.WriteLine();
}

foreach (var row in workSheet.Rows)
{
    foreach (var cell in row)
    {
        Console.Write(cell.Text + "\t");
    }
    Console.WriteLine();
}

Imports Microsoft.VisualBasic

For Each row In workSheet.Rows
	For Each cell In row
		Console.Write(cell.Text & vbTab)
	Next cell
	Console.WriteLine()
Next row

workBook.Close();

workBook.Close();

workBook.Close()

Conclusion

In this tutorial, we explored the process of reading Excel files in a C# Console Application using the IronXL library. With its intuitive features, IronXL simplifies Excel-related tasks, making it a valuable tool for .NET developers working on data-centric applications.

Feel free to explore additional functionalities provided by IronXL for more advanced Excel manipulations in your C# projects by visiting this documentation page.

IronXL offers a free trial for testing out its complete functionality before making an informed decision. For commercial use, you need to purchase a license key starting from $799.

For more information on license packages, please visit this license page. Download the library from here and give it a try.