A Guide to Reading and Writing Excel Files in C

Name: IronXL
Brand: Iron Software
Availability: InStock
Rating: 4.67 (175 reviews)

Curtis Chau

更新:2025年6月10日

Translated

View the article in English

使用Iron Software的IronXL軟體庫，在 C# 和其他.NET語言中讀取和建立 Excel (XLS、XLSX 和 CSV) 檔案非常容易。

IronXL不需要在您的伺服器上安裝 Excel Interop。 IronXL提供比Microsoft.Office.Interop.Excel更快、更直覺的 API。

IronXL可在以下平台上運作：

適用於 Windows 和 Azure 的.NET Framework 4.6.2 及更高版本
適用於 Windows、Linux、MacOS 和 Azure 的.NET Core 2 及更高版本
.NET 5、 .NET 6、 .NET 7、 .NET 8、Mono、Maui 和 Xamarin

安裝IronXL

Firstly install IronXL, using our NuGet package or by downloading the DLL. IronXL classes can be found in the IronXL namespace.

安裝IronXL最簡單的方法是使用 Visual Studio 的NuGet套件管理器：軟體套件名稱為IronXL 。

Install-Package IronXl.Excel

https://www.nuget.org/packages/ironxl.excel/

讀取 Excel 文檔

使用IronXL，只需幾行程式碼即可從 Excel 檔案中提取資料。

:path=/static-assets/excel/content-code-examples/get-started/get-started-1.cs

using IronXL;

// Supported spreadsheet formats for reading include: XLSX, XLS, CSV and TSV
WorkBook workBook = WorkBook.Load("data.xlsx");
WorkSheet workSheet = workBook.WorkSheets.First();

// Select cells easily in Excel notation and return the calculated value, date, text or formula
int cellValue = workSheet["A2"].IntValue;

// Read from Ranges of cells elegantly.
foreach (var cell in workSheet["A2:B10"])
{
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

$vbLabelText $csharpLabel

建立新的Excel文檔

IronXL提供了一個快速簡單的介面，可以使用 C# 或.NET產生 Excel 文件。

:path=/static-assets/excel/content-code-examples/get-started/get-started-2.cs

using IronXL;

// Create new Excel WorkBook document.
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
workBook.Metadata.Author = "IronXL";

// Add a blank WorkSheet
WorkSheet workSheet = workBook.CreateWorkSheet("main_sheet");

// Add data and styles to the new worksheet
workSheet["A1"].Value = "Hello World";
workSheet["A2"].Style.BottomBorder.SetColor("#ff6600");
workSheet["A2"].Style.BottomBorder.Type = IronXL.Styles.BorderType.Double;

// Save the excel file
workBook.SaveAs("NewExcelFile.xlsx");

$vbLabelText $csharpLabel

匯出格式為 CSV、XLS、XLSX、JSON 或 XML

IronXL還允許您將資料儲存或匯出為各種流行的結構化電子表格格式。

:path=/static-assets/excel/content-code-examples/get-started/get-started-3.cs

// Export to many formats with fluent saving
workSheet.SaveAs("NewExcelFile.xls");
workSheet.SaveAs("NewExcelFile.xlsx");
workSheet.SaveAsCsv("NewExcelFile.csv");
workSheet.SaveAsJson("NewExcelFile.json");
workSheet.SaveAsXml("NewExcelFile.xml");

$vbLabelText $csharpLabel

設定單元格和區域的樣式

您可以使用IronXl.Range.Style 物件對 Excel 儲存格和區域套用格式。

:path=/static-assets/excel/content-code-examples/get-started/get-started-4.cs

// Set cell's value and styles
workSheet["A1"].Value = "Hello World";
workSheet["A2"].Style.BottomBorder.SetColor("#ff6600");
workSheet["A2"].Style.BottomBorder.Type = IronXL.Styles.BorderType.Double;

$vbLabelText $csharpLabel

排序範圍

使用IronXL，您可以利用 Range 物件輕鬆地對一系列 Excel 儲存格進行排序。

:path=/static-assets/excel/content-code-examples/get-started/get-started-5.cs

using IronXL;
using Range = IronXL.Range;

WorkBook workBook = WorkBook.Load("test.xls");
WorkSheet workSheet = workBook.WorkSheets.First();

// This is how we get range from Excel worksheet
Range range = workSheet["A2:A8"];

// Sort the range in the sheet
range.SortAscending();
workBook.Save();

$vbLabelText $csharpLabel

編輯公式

修改 Excel 公式就像賦值一個以"=""符號開頭的值一樣簡單。公式將立即計算出來。

:path=/static-assets/excel/content-code-examples/get-started/get-started-6.cs

// Set a formula
workSheet["A1"].Value = "=SUM(A2:A10)";

// Get the calculated value
decimal sum = workSheet["A1"].DecimalValue;

$vbLabelText $csharpLabel

為什麼選擇IronXL？

IronXL為.NET中的開發者提供了一個對 Excel 文件讀寫友善的 API。它無需在伺服器上安裝 Microsoft Excel 或 Excel Interop 即可運作，使 Excel 文件處理快速、輕巧且無麻煩。

展望未來

若要了解更多功能和功能，我們建議您查看格式與 MSDN 文件類似的.NET API 參考文件。

Curtis Chau

立即與工程團隊聊天

技術作家

Curtis Chau 擁有卡爾頓大學計算機科學學士學位，專注於前端開發，擅長於 Node.js、TypeScript、JavaScript 和 React。Curtis 熱衷於創建直觀且美觀的用戶界面，喜歡使用現代框架並打造結構良好、視覺吸引人的手冊。

除了開發之外，Curtis 對物聯網 (IoT) 有著濃厚的興趣，探索將硬體和軟體結合的創新方式。在閒暇時間，他喜愛遊戲並構建 Discord 機器人，結合科技與創意的樂趣。

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/ready_to_started_202509.php
Line: 12
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 489
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Docs.php
Line: 29
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/ready_to_started_202509.php
Line: 19
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 489
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Docs.php
Line: 29
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

準備好開始了嗎？

Nuget 下載 1,890,100 | 版本： 2026.3 剛剛發布

查看許可證

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/still_scrolling_202512.php
Line: 17
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/views/products/sections/three_column_docs_page_structure.php
Line: 71
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/views/products/docs/docs.php
Line: 2
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 550
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Docs.php
Line: 29
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/still_scrolling_202512.php
Line: 24
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/views/products/sections/three_column_docs_page_structure.php
Line: 71
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/views/products/docs/docs.php
Line: 2
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 550
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Docs.php
Line: 29
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

還在捲動嗎？

想要快速證明？ PM > Install-Package IronXl.Excel
執行範例觀看您的資料變成試算表。

查看許可證

客戶亮點：

開發者焦點：

網路研討會：

開始免費 30 天試用

A Guide to Reading and Writing Excel Files in C

安裝IronXL

讀取 Excel 文檔

建立新的Excel文檔

匯出格式為 CSV、XLS、XLSX、JSON 或 XML

設定單元格和區域的樣式

排序範圍

編輯公式

為什麼選擇IronXL？

展望未來

A PHP Error was encountered

A PHP Error was encountered

在這頁

A PHP Error was encountered

A PHP Error was encountered

還在捲動嗎？

IronXL 是 IRONSUITE 的一部分

Iron Support Team

開始免費 30 天試用

A Guide to Reading and Writing Excel Files in C

安裝IronXL

讀取 Excel 文檔

建立新的Excel文檔

匯出格式為 CSV、XLS、XLSX、JSON 或 XML

設定單元格和區域的樣式

排序範圍

編輯公式

為什麼選擇IronXL？

展望未來

A PHP Error was encountered

A PHP Error was encountered

在這頁

A PHP Error was encountered

A PHP Error was encountered

還在捲動嗎？

獲取您的免費

下一步：開始免費 30 天試用

下一步：開始免費 30 天試用

深受全球數百萬工程師信賴

IronXL 是 IRONSUITE 的一部分

產品連結

Iron Support Team