
VB .NET Excel 函式庫
- 用於在 .NET 中建立 Excel 工作表的 Visual Basic API
- 在 VB.NET 中讀取、更新及建立 Excel 試算表檔案
- 無需 Microsoft Office 或 Excel 互通功能
- 全面支援 .NET Core、Framework、Xamarin、行動裝置及 Azure
透過程式碼範例開始使用
using IronXL;
// Create new Excel spreadsheet
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
// Create worksheets (workSheet1, workSheet2, workSheet3)
WorkSheet workSheet1 = workBook.CreateWorkSheet("workSheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("workSheet2");
WorkSheet workSheet3 = workBook.CreateWorkSheet("workSheet3");
// Set worksheet position (workSheet2, workSheet1, workSheet3)
workBook.SetSheetPosition("workSheet2", 0);
// Set active for workSheet3
workBook.SetActiveTab(2);
// Remove workSheet1
workBook.RemoveWorkSheet(1);
workBook.SaveAs("manageWorkSheet.xlsx");
using IronXL;
// Create new Excel spreadsheet
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
// Create worksheets (workSheet1, workSheet2, workSheet3)
WorkSheet workSheet1 = workBook.CreateWorkSheet("workSheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("workSheet2");
WorkSheet workSheet3 = workBook.CreateWorkSheet("workSheet3");
// Set worksheet position (workSheet2, workSheet1, workSheet3)
workBook.SetSheetPosition("workSheet2", 0);
// Set active for workSheet3
workBook.SetActiveTab(2);
// Remove workSheet1
workBook.RemoveWorkSheet(1);
workBook.SaveAs("manageWorkSheet.xlsx");
using IronXL;
// Create new Excel spreadsheet
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);
// Create worksheets (workSheet1, workSheet2, workSheet3)
WorkSheet workSheet1 = workBook.CreateWorkSheet("workSheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("workSheet2");
WorkSheet workSheet3 = workBook.CreateWorkSheet("workSheet3");
// Set worksheet position (workSheet2, workSheet1, workSheet3)
workBook.SetSheetPosition("workSheet2", 0);
// Set active for workSheet3
workBook.SetActiveTab(2);
// Remove workSheet1
workBook.RemoveWorkSheet(1);
workBook.SaveAs("manageWorkSheet.xlsx");
Imports IronXL
' Create new Excel spreadsheet
Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
' Create worksheets (workSheet1, workSheet2, workSheet3)
Dim workSheet1 As WorkSheet = workBook.CreateWorkSheet("workSheet1")
Dim workSheet2 As WorkSheet = workBook.CreateWorkSheet("workSheet2")
Dim workSheet3 As WorkSheet = workBook.CreateWorkSheet("workSheet3")
' Set worksheet position (workSheet2, workSheet1, workSheet3)
workBook.SetSheetPosition("workSheet2", 0)
' Set active for workSheet3
workBook.SetActiveTab(2)
' Remove workSheet1
workBook.RemoveWorkSheet(1)
workBook.SaveAs("manageWorkSheet.xlsx")Imports IronXL
' Create new Excel spreadsheet
Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
' Create worksheets (workSheet1, workSheet2, workSheet3)
Dim workSheet1 As WorkSheet = workBook.CreateWorkSheet("workSheet1")
Dim workSheet2 As WorkSheet = workBook.CreateWorkSheet("workSheet2")
Dim workSheet3 As WorkSheet = workBook.CreateWorkSheet("workSheet3")
' Set worksheet position (workSheet2, workSheet1, workSheet3)
workBook.SetSheetPosition("workSheet2", 0)
' Set active for workSheet3
workBook.SetActiveTab(2)
' Remove workSheet1
workBook.RemoveWorkSheet(1)
workBook.SaveAs("manageWorkSheet.xlsx")Imports IronXL
' Create new Excel spreadsheet
Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
' Create worksheets (workSheet1, workSheet2, workSheet3)
Dim workSheet1 As WorkSheet = workBook.CreateWorkSheet("workSheet1")
Dim workSheet2 As WorkSheet = workBook.CreateWorkSheet("workSheet2")
Dim workSheet3 As WorkSheet = workBook.CreateWorkSheet("workSheet3")
' Set worksheet position (workSheet2, workSheet1, workSheet3)
workBook.SetSheetPosition("workSheet2", 0)
' Set active for workSheet3
workBook.SetActiveTab(2)
' Remove workSheet1
workBook.RemoveWorkSheet(1)
workBook.SaveAs("manageWorkSheet.xlsx")IronXL程式庫讓您能透過 C# 程式碼以最簡便的方式管理試算表。 在 Excel 檔案中建立與刪除工作表、變更工作表位置,以及設定工作表為活躍工作表等操作,皆無需使用 Office Interop 即可實現。
建立工作表
CreateWorkSheet 方法可建立工作表。 它僅需工作表名稱作為唯一參數。
- 此程式碼片段會建立一個新的工作簿,並在該工作簿內建立一個名為"NewSheet"的新工作表。
設定工作表位置
可使用 SetSheetPosition 方法來變更或移動工作表的位置。 需提供兩個參數:工作表名稱(格式為 string)及其索引位置(格式為 integer)。
- 此操作會將名為"SheetName"的工作表位置調整至工作簿中的第二個位置(請注意,索引從零開始)。
設定活動工作表
設定"工作表"即指指定在開啟工作簿時,預設將開啟哪一張工作表。 為達成此目標,請使用 SetActiveTab 方法並指定工作表的索引位置。
- 此設定將第一個工作表設為預設開啟的活躍分頁。
移除工作表
using IronXL 亦可移除工作表。 請使用 RemoveWorkSheet 方法,並配合工作表的索引位置。 若工作表的位置未知,亦可使用工作表名稱來刪除它。
- 第一個範例是根據索引刪除工作簿中的第一個工作表。
- 第二個範例會移除名為"SheetName"的工作表。
請注意,上述所有索引位置均採用零起始索引,即第一個元素的索引為 0。
如何在 C# 中管理 Excel 工作表
- 安裝 C# 函式庫以管理 Excel 工作表
- 請使用
CreateWorkSheet方法來建立工作表 - 使用 C# 變更工作表位置
SetSheetPosition - 請使用
SetActiveTab來設定預設開啟的工作表 - 使用
RemoveWorkSheetC# 函式
using IronXL;
using System;
using System.Linq;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];
// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;
// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;
// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}
// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();
// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);
using IronXL;
using System;
using System.Linq;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];
// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;
// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;
// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}
// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();
// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);
using IronXL;
using System;
using System.Linq;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];
// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;
// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;
// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}
// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();
// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);
Imports IronXL
Imports System
Imports System.Linq
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Select worksheet at index 0
Dim workSheet As WorkSheet = workBook.WorkSheets(0)
' Get any existing worksheet
Dim firstSheet As WorkSheet = workBook.DefaultWorkSheet
' Select a cell and return the converted value
Dim cellValue As Integer = workSheet("A2").IntValue
' Read from ranges of cells elegantly.
For Each cell In workSheet("A2:A10")
Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
Next
' Calculate aggregate values such as Min, Max and Sum
Dim sum As Decimal = workSheet("A2:A10").Sum()
' Linq compatible
Dim max As Decimal = workSheet("A2:A10").Max(Function(c) c.DecimalValue)Imports IronXL
Imports System
Imports System.Linq
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Select worksheet at index 0
Dim workSheet As WorkSheet = workBook.WorkSheets(0)
' Get any existing worksheet
Dim firstSheet As WorkSheet = workBook.DefaultWorkSheet
' Select a cell and return the converted value
Dim cellValue As Integer = workSheet("A2").IntValue
' Read from ranges of cells elegantly.
For Each cell In workSheet("A2:A10")
Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
Next
' Calculate aggregate values such as Min, Max and Sum
Dim sum As Decimal = workSheet("A2:A10").Sum()
' Linq compatible
Dim max As Decimal = workSheet("A2:A10").Max(Function(c) c.DecimalValue)Imports IronXL
Imports System
Imports System.Linq
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Select worksheet at index 0
Dim workSheet As WorkSheet = workBook.WorkSheets(0)
' Get any existing worksheet
Dim firstSheet As WorkSheet = workBook.DefaultWorkSheet
' Select a cell and return the converted value
Dim cellValue As Integer = workSheet("A2").IntValue
' Read from ranges of cells elegantly.
For Each cell In workSheet("A2:A10")
Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
Next
' Calculate aggregate values such as Min, Max and Sum
Dim sum As Decimal = workSheet("A2:A10").Sum()
' Linq compatible
Dim max As Decimal = workSheet("A2:A10").Max(Function(c) c.DecimalValue)IronXL中的Load功能使您能輕鬆載入和操作各種格式(XLSX、XLS、CSV等)的現有Excel文件。 通過載入WorkSheets和資料,從而使您可以提取數值、遍歷單元格範圍,並進行如求和或最大值等計算。 您可以存取特定單元格,將其值轉換為適當的資料型別(例如整數、小數),甚至可以使用LINQ進行高級資料操作。 此功能簡化了在.NET中處理Excel資料的過程,使其成為資料分析、報告生成和自動化等任務的理想選擇。
從Excel文件載入並計算總和的5個步驟
WorkBook workBook = WorkBook.Load("sample.xlsx");WorkSheet workSheet = workBook.WorkSheets[0];var range = workSheet["A2:A10"];decimal sum = range.Sum();Console.WriteLine("範圍A2:A10的總和是: " + sum);
WorkBook物件是在IronXL中與Excel文件互動的關鍵起點。 使用WorkBook.Load("sample.xlsx")方法開啟現有的Excel文件,從而可進一步操作其內容和結構。 這允許開發者處理預先存在的資料,自動化任務,並在不需要重新建立新表的情況下更新電子表格。
接下來,使用WorkSheets[0]屬性來存取活頁簿中的第一個工作表。 在Excel中,一個活頁簿可以包含多個工作表,每個工作表表示一組按行與列組織的資料。 選擇第一個工作表意味著您正在定位儲存資料的主要區域,即您將在此進行讀取數值或計算結果等操作。
A10之間的範圍。 這就是為什麼IronXL允許您一次與多個單元格互動,無論是通過讀取數值、應用格式化還是跨範圍進行計算。 在這個例子中,它捕捉了一個列範圍,讓您更容易處理順序資料。
.Sum()方法用於計算所選範圍內數值的總和。 這顯示了IronXL如何允許開發者在資料範圍上進行快速的內建計算,消除了手動迭代和求和的必要性。
最後,Console.WriteLine()語句將計算出的總和輸出到控制台。 這是一種簡單但強大的方式,可以在應用程式內部直接顯示操作結果,例如範圍內的數值總和。
通過這種方法,開發者可以輕鬆地自動化資料匯總任務或將其整合到更大的工作流程中。
學習如何使用IronXL載入和操作Excel文件using IronXL;
// Create new Excel WorkBook document
WorkBook workBook = WorkBook.Create();
// Convert XLSX to XLS
WorkBook xlsWorkBook = WorkBook.Create(ExcelFileFormat.XLS);
// Create a blank WorkSheet
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");
// Add data and styles to the new worksheet
workSheet["A1"].Value = "Hello World";
workSheet["A1"].Style.WrapText = true;
workSheet["A2"].BoolValue = true;
workSheet["A2"].Style.BottomBorder.Type = IronXL.Styles.BorderType.Double;
// Save the excel file as XLS, XLSX, CSV, TSV, JSON, XML, HTML and streams
workBook.SaveAs("sample.xlsx");
using IronXL;
// Create new Excel WorkBook document
WorkBook workBook = WorkBook.Create();
// Convert XLSX to XLS
WorkBook xlsWorkBook = WorkBook.Create(ExcelFileFormat.XLS);
// Create a blank WorkSheet
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");
// Add data and styles to the new worksheet
workSheet["A1"].Value = "Hello World";
workSheet["A1"].Style.WrapText = true;
workSheet["A2"].BoolValue = true;
workSheet["A2"].Style.BottomBorder.Type = IronXL.Styles.BorderType.Double;
// Save the excel file as XLS, XLSX, CSV, TSV, JSON, XML, HTML and streams
workBook.SaveAs("sample.xlsx");
using IronXL;
// Create new Excel WorkBook document
WorkBook workBook = WorkBook.Create();
// Convert XLSX to XLS
WorkBook xlsWorkBook = WorkBook.Create(ExcelFileFormat.XLS);
// Create a blank WorkSheet
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");
// Add data and styles to the new worksheet
workSheet["A1"].Value = "Hello World";
workSheet["A1"].Style.WrapText = true;
workSheet["A2"].BoolValue = true;
workSheet["A2"].Style.BottomBorder.Type = IronXL.Styles.BorderType.Double;
// Save the excel file as XLS, XLSX, CSV, TSV, JSON, XML, HTML and streams
workBook.SaveAs("sample.xlsx");
Imports IronXL
' Create new Excel WorkBook document
Dim workBook As WorkBook = WorkBook.Create()
' Convert XLSX to XLS
Dim xlsWorkBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLS)
' Create a blank WorkSheet
Dim workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")
' Add data and styles to the new worksheet
workSheet("A1").Value = "Hello World"
workSheet("A1").Style.WrapText = True
workSheet("A2").BoolValue = True
workSheet("A2").Style.BottomBorder.Type = IronXL.Styles.BorderType.Double
' Save the excel file as XLS, XLSX, CSV, TSV, JSON, XML, HTML and streams
workBook.SaveAs("sample.xlsx")Imports IronXL
' Create new Excel WorkBook document
Dim workBook As WorkBook = WorkBook.Create()
' Convert XLSX to XLS
Dim xlsWorkBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLS)
' Create a blank WorkSheet
Dim workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")
' Add data and styles to the new worksheet
workSheet("A1").Value = "Hello World"
workSheet("A1").Style.WrapText = True
workSheet("A2").BoolValue = True
workSheet("A2").Style.BottomBorder.Type = IronXL.Styles.BorderType.Double
' Save the excel file as XLS, XLSX, CSV, TSV, JSON, XML, HTML and streams
workBook.SaveAs("sample.xlsx")Imports IronXL
' Create new Excel WorkBook document
Dim workBook As WorkBook = WorkBook.Create()
' Convert XLSX to XLS
Dim xlsWorkBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLS)
' Create a blank WorkSheet
Dim workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")
' Add data and styles to the new worksheet
workSheet("A1").Value = "Hello World"
workSheet("A1").Style.WrapText = True
workSheet("A2").BoolValue = True
workSheet("A2").Style.BottomBorder.Type = IronXL.Styles.BorderType.Double
' Save the excel file as XLS, XLSX, CSV, TSV, JSON, XML, HTML and streams
workBook.SaveAs("sample.xlsx")生成 Excel 的功能為開發者提供了一種強大的方式,可以直接在 .NET 應用程式中生成和管理 Excel 文件。
它簡化了建立新簿、新增工作表和輸入資料等任務,並提供了如文字換行、邊框和格式化等進階樣式選項。 這個功能非常適合用於自動化報告、資料匯出或動態電子表格的建立。 IronXL 支援多種檔案格式,包括 XLS、XLSX、CSV 等,確保與各系統的相容性。 透過其使用者友好的 API,開發者可以專注於核心功能,同時節省時間並減少 Excel 文件管理的複雜性。
使用 IronXL 建立與設計 Excel 文件的五個步驟
WorkBook workBook = WorkBook.Create();WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");workSheet["A1"].Value = "Hello World";workSheet["A1"].Style.WrapText = true;workBook.SaveAs("sample.xlsx");
WorkBook 物件是任何 Excel 文件的基礎。通過初始化新工作簿,開發者可以使用空白的 Excel 文件,準備好填充資料並根據需要進行格式化。
每個 Excel 工作簿至少需要一個工作表。 下一步演示了如何在工作簿中建立新工作表並為其分配自定義名稱。 工作表作為按行和列組織資料的主要結構。
此程式碼片段展示了如何通過將值 "Hello World" 指定給特定單元格 A1 來新增內容。 這展示了如何輕鬆地以程式化方式將資料填充到 Excel 表格中,使開發者能夠自動化如報告生成和資料匯出等任務。
另外,程式碼片段通過啟用 WrapText 屬性來應用樣式到單元格中。 這確保了單元格中的冗長內容被整齊地顯示在多行上,提高了可讀性並防止文字被截斷。 這類樣式選項使開發者能夠建立視覺上吸引且專業的電子表格。
using IronXL;
using System.IO;
// Import any XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML
workBook.SaveAs("sample.xls");
workBook.SaveAs("sample.xlsx");
workBook.SaveAs("sample.tsv");
workBook.SaveAsCsv("sample.csv");
workBook.SaveAsJson("sample.json");
workBook.SaveAsXml("sample.xml");
// Export the excel file as Html, Html string
workBook.ExportToHtml("sample.html");
string htmlString = workBook.ExportToHtmlString();
// Export the excel file as Binary, Byte array, Data set, Stream
byte[] binary = workBook.ToBinary();
byte[] byteArray = workBook.ToByteArray();
System.Data.DataSet dataSet = workBook.ToDataSet(); // Allow easy integration with DataGrids, SQL and EF
Stream stream = workBook.ToStream();
using IronXL;
using System.IO;
// Import any XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML
workBook.SaveAs("sample.xls");
workBook.SaveAs("sample.xlsx");
workBook.SaveAs("sample.tsv");
workBook.SaveAsCsv("sample.csv");
workBook.SaveAsJson("sample.json");
workBook.SaveAsXml("sample.xml");
// Export the excel file as Html, Html string
workBook.ExportToHtml("sample.html");
string htmlString = workBook.ExportToHtmlString();
// Export the excel file as Binary, Byte array, Data set, Stream
byte[] binary = workBook.ToBinary();
byte[] byteArray = workBook.ToByteArray();
System.Data.DataSet dataSet = workBook.ToDataSet(); // Allow easy integration with DataGrids, SQL and EF
Stream stream = workBook.ToStream();
using IronXL;
using System.IO;
// Import any XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML
workBook.SaveAs("sample.xls");
workBook.SaveAs("sample.xlsx");
workBook.SaveAs("sample.tsv");
workBook.SaveAsCsv("sample.csv");
workBook.SaveAsJson("sample.json");
workBook.SaveAsXml("sample.xml");
// Export the excel file as Html, Html string
workBook.ExportToHtml("sample.html");
string htmlString = workBook.ExportToHtmlString();
// Export the excel file as Binary, Byte array, Data set, Stream
byte[] binary = workBook.ToBinary();
byte[] byteArray = workBook.ToByteArray();
System.Data.DataSet dataSet = workBook.ToDataSet(); // Allow easy integration with DataGrids, SQL and EF
Stream stream = workBook.ToStream();
Imports IronXL
Imports System.IO
' Import any XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML
workBook.SaveAs("sample.xls")
workBook.SaveAs("sample.xlsx")
workBook.SaveAs("sample.tsv")
workBook.SaveAsCsv("sample.csv")
workBook.SaveAsJson("sample.json")
workBook.SaveAsXml("sample.xml")
' Export the excel file as Html, Html string
workBook.ExportToHtml("sample.html")
Dim htmlString As String = workBook.ExportToHtmlString()
' Export the excel file as Binary, Byte array, Data set, Stream
Dim binary As Byte() = workBook.ToBinary()
Dim byteArray As Byte() = workBook.ToByteArray()
Dim dataSet As System.Data.DataSet = workBook.ToDataSet() ' Allow easy integration with DataGrids, SQL and EF
Dim stream As Stream = workBook.ToStream()Imports IronXL
Imports System.IO
' Import any XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML
workBook.SaveAs("sample.xls")
workBook.SaveAs("sample.xlsx")
workBook.SaveAs("sample.tsv")
workBook.SaveAsCsv("sample.csv")
workBook.SaveAsJson("sample.json")
workBook.SaveAsXml("sample.xml")
' Export the excel file as Html, Html string
workBook.ExportToHtml("sample.html")
Dim htmlString As String = workBook.ExportToHtmlString()
' Export the excel file as Binary, Byte array, Data set, Stream
Dim binary As Byte() = workBook.ToBinary()
Dim byteArray As Byte() = workBook.ToByteArray()
Dim dataSet As System.Data.DataSet = workBook.ToDataSet() ' Allow easy integration with DataGrids, SQL and EF
Dim stream As Stream = workBook.ToStream()Imports IronXL
Imports System.IO
' Import any XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML
workBook.SaveAs("sample.xls")
workBook.SaveAs("sample.xlsx")
workBook.SaveAs("sample.tsv")
workBook.SaveAsCsv("sample.csv")
workBook.SaveAsJson("sample.json")
workBook.SaveAsXml("sample.xml")
' Export the excel file as Html, Html string
workBook.ExportToHtml("sample.html")
Dim htmlString As String = workBook.ExportToHtmlString()
' Export the excel file as Binary, Byte array, Data set, Stream
Dim binary As Byte() = workBook.ToBinary()
Dim byteArray As Byte() = workBook.ToByteArray()
Dim dataSet As System.Data.DataSet = workBook.ToDataSet() ' Allow easy integration with DataGrids, SQL and EF
Dim stream As Stream = workBook.ToStream()IronXL 提供了一種簡單且靈活的方式,讓開發者能夠處理 Excel 文件,允許輕鬆地在各種格式之間進行導入和導出。 它支持的文件型別如 XML 和 HTML,使其非常適合不同應用的需求。 開發者可以將 Excel 資料轉換為適合網頁整合、API 或進一步資料處理的格式,只需幾行程式碼即可實現。
例如,將 Excel 文件導出為 HTML 或 JSON 格式,便於將資料嵌入到 Web 應用程式中,而轉換為二進制、位元組陣列或流則有助於與資料庫或其他系統整合。 將 Excel 內容轉換為 DataSet 簡化了與 SQL 資料庫連接或填充像資料網格這樣的 UI 組件的過程。 這減少了手工編碼,提升了生產力,使得 IronXL 成為現代資料驅動應用程式中一個有價值的工具。
出口 Excel 文件為多種格式的 5 個步驟
此程式碼展示了 IronXL 在處理及導出 Excel 資料到多種格式時的多功能性。 過程從將現有 Excel 文件 Sample.xlsx 載入到 WorkBook 物件中開始。 此物件作為操縱和導出資料的中央樞紐。 利用 SaveAs 方法,workbook 被保存為 .xlsx 文件,以確保與現代 Excel 應用程式的相容性。
接下來,SaveAsJson 方法將 workbook 轉換為 JSON 格式,使其適合用於 API 響應或輕量級資料交換。 ToDataSet 方法通過將 workbook 轉換為 DataSet 物件,使其能夠與資料庫或 UI 組件無縫整合,這是一種 .NET 原生的結構用於處理表格式資料。
最後,ExportToHtml 方法生成一個 HTML 文件,使得開發者能夠直接在網頁上顯示 Excel 資料。 這些功能簡化了資料處理任務,使 IronXL 成為操作 Excel 文件的開發者一個卓越的工具。
using IronXL;
using System;
using System.Data;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Convert the whole Excel WorkBook to a DataSet
DataSet dataSet = workBook.ToDataSet();
foreach (DataTable table in dataSet.Tables)
{
Console.WriteLine(table.TableName);
// Enumerate by rows or columns first at your preference
foreach (DataRow row in table.Rows)
{
for (int i = 0 ; i < table.Columns.Count ; i++)
{
Console.Write(row[i]);
}
}
}
using IronXL;
using System;
using System.Data;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Convert the whole Excel WorkBook to a DataSet
DataSet dataSet = workBook.ToDataSet();
foreach (DataTable table in dataSet.Tables)
{
Console.WriteLine(table.TableName);
// Enumerate by rows or columns first at your preference
foreach (DataRow row in table.Rows)
{
for (int i = 0 ; i < table.Columns.Count ; i++)
{
Console.Write(row[i]);
}
}
}
using IronXL;
using System;
using System.Data;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Convert the whole Excel WorkBook to a DataSet
DataSet dataSet = workBook.ToDataSet();
foreach (DataTable table in dataSet.Tables)
{
Console.WriteLine(table.TableName);
// Enumerate by rows or columns first at your preference
foreach (DataRow row in table.Rows)
{
for (int i = 0 ; i < table.Columns.Count ; i++)
{
Console.Write(row[i]);
}
}
}
Imports IronXL
Imports System
Imports System.Data
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Convert the whole Excel WorkBook to a DataSet
Dim dataSet As DataSet = workBook.ToDataSet()
For Each table As DataTable In dataSet.Tables
Console.WriteLine(table.TableName)
' Enumerate by rows or columns first at your preference
For Each row As DataRow In table.Rows
For i As Integer = 0 To table.Columns.Count - 1
Console.Write(row(i))
Next
Next
NextImports IronXL
Imports System
Imports System.Data
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Convert the whole Excel WorkBook to a DataSet
Dim dataSet As DataSet = workBook.ToDataSet()
For Each table As DataTable In dataSet.Tables
Console.WriteLine(table.TableName)
' Enumerate by rows or columns first at your preference
For Each row As DataRow In table.Rows
For i As Integer = 0 To table.Columns.Count - 1
Console.Write(row(i))
Next
Next
NextImports IronXL
Imports System
Imports System.Data
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Convert the whole Excel WorkBook to a DataSet
Dim dataSet As DataSet = workBook.ToDataSet()
For Each table As DataTable In dataSet.Tables
Console.WriteLine(table.TableName)
' Enumerate by rows or columns first at your preference
For Each row As DataRow In table.Rows
For i As Integer = 0 To table.Columns.Count - 1
Console.Write(row(i))
Next
Next
Next將任何DataGrid。 此DataTable物件可以包含表格、關係和約束的集合。
DataTables in C# with our guide.using IronXL;
using System;
using System.Data;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Select default sheet
WorkSheet workSheet = workBook.DefaultWorkSheet;
// Convert the worksheet to DataTable
DataTable dataTable = workSheet.ToDataTable(true);
// Enumerate by rows or columns first at your preference
foreach (DataRow row in dataTable.Rows)
{
for (int i = 0 ; i < dataTable.Columns.Count ; i++)
{
Console.Write(row[i]);
}
}
using IronXL;
using System;
using System.Data;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Select default sheet
WorkSheet workSheet = workBook.DefaultWorkSheet;
// Convert the worksheet to DataTable
DataTable dataTable = workSheet.ToDataTable(true);
// Enumerate by rows or columns first at your preference
foreach (DataRow row in dataTable.Rows)
{
for (int i = 0 ; i < dataTable.Columns.Count ; i++)
{
Console.Write(row[i]);
}
}
using IronXL;
using System;
using System.Data;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Select default sheet
WorkSheet workSheet = workBook.DefaultWorkSheet;
// Convert the worksheet to DataTable
DataTable dataTable = workSheet.ToDataTable(true);
// Enumerate by rows or columns first at your preference
foreach (DataRow row in dataTable.Rows)
{
for (int i = 0 ; i < dataTable.Columns.Count ; i++)
{
Console.Write(row[i]);
}
}
Imports IronXL
Imports System
Imports System.Data
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Select default sheet
Dim workSheet As WorkSheet = workBook.DefaultWorkSheet
' Convert the worksheet to DataTable
Dim dataTable As DataTable = workSheet.ToDataTable(True)
' Enumerate by rows or columns first at your preference
For Each row As DataRow In dataTable.Rows
For i As Integer = 0 To dataTable.Columns.Count - 1
Console.Write(row(i))
Next
NextImports IronXL
Imports System
Imports System.Data
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Select default sheet
Dim workSheet As WorkSheet = workBook.DefaultWorkSheet
' Convert the worksheet to DataTable
Dim dataTable As DataTable = workSheet.ToDataTable(True)
' Enumerate by rows or columns first at your preference
For Each row As DataRow In dataTable.Rows
For i As Integer = 0 To dataTable.Columns.Count - 1
Console.Write(row(i))
Next
NextImports IronXL
Imports System
Imports System.Data
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Select default sheet
Dim workSheet As WorkSheet = workBook.DefaultWorkSheet
' Convert the worksheet to DataTable
Dim dataTable As DataTable = workSheet.ToDataTable(True)
' Enumerate by rows or columns first at your preference
For Each row As DataRow In dataTable.Rows
For i As Integer = 0 To dataTable.Columns.Count - 1
Console.Write(row(i))
Next
Next將XLSX, XLS, XLSM, XLTX, DataGrid。
輸入ToDataTable方法以將第一列設為表格的列名稱。 DataGrid。
How to Convert Excel to SQL DataTable in C#
- 安裝一個Excel程式庫將Excel轉換為SQL
DataTable。 - 選擇預設的
Worksheet - 使用
ToDataTable從資料建立DataTable。 - 迭代處理值。
DataTable to Excel in C#
來自我們 VB .NET 開發團隊的直接支援
Iron Visual Basic .NET 產品開發團隊隨時準備為您解答疑問。歡迎聯繫我們,讓您的專案充分發揮此函式庫的優勢。
在 VB.NET 中處理 Excel 檔案
在 Visual Basic VB.NET 中快速處理 Excel 試算表的解決方案。 適用於 VB .NET Core 和 Azure,無需特殊依賴項,亦無需安裝 MS Office 或 Interop。
在 VB.NET 中讀取與寫入 Excel 檔案
IronXL 讓您能在 .NET 應用程式中讀取試算表中的 Excel 資料。讀取與編輯 XLS/XLSX/CSV/TSV 檔案,並儲存及匯出為 XLS/XLSX/CSV/TSV/JSON 格式。
原生 SQL 支援
透過將工作表視為 System.Data.DataSet 和 System.Data.DataTable 物件,在 Excel、SQL 和 GridView 之間傳輸資料。
在 Visual Basic .NET 中更新 Excel 資料
支援 Microsoft Excel 公式 - 若工作表更新,將自動重新計算。採用簡易易用的 WorkSheet [“A1:B10”] 語法。可依範圍、欄位及列進行排序。
using VB 設定 Excel 工作表儲存格樣式
設定字型、大小、背景、邊框、對齊方式及數字格式。安裝至 Microsoft Visual Studio
IronXL 提供 Excel 生成與編輯工具。可直接從 NuGet 安裝,或下載 DLL 檔案。支援:
VB .NET Excel 試算表教學


如何在 .NET 中建立 Excel 檔案
參閱 Jonas 如何運用 IronXL 在不使用 Office Interop 的情況下產生 Excel 檔案...
查看 Jonas 的 Excel 檔案生成教學



Professional開發人員使用 IronXL 來...
會計與財務系統
- # 收據
- # 報告
- # 發票列印
企業數位化
- # 文件說明
- # 排序與標籤
- # 紙本替代方案

Enterprise內容管理
- # 內容製作
- # 文件管理
- # 內容分發

資料與報表應用程式
- # 效能追蹤
- # 趨勢圖譜
- # 報告

數以千計的企業、政府機構、中小企業及開發者皆信賴 Iron Software產品。
Team Iron 在 .NET 軟體元件市場擁有超過 10 年的經驗。








產品連結
- - 建立、閱讀及編輯 PDF 文件。HTML 轉 PDF 工具。IRONPDF
- - 編輯 DOCX WORD 檔案。無需 Office 互通功能。IRONWORD
- - 編輯 Excel 與 CSV 檔案。無需 Office 互通功能。IRONXL
- - 建立、閱讀及編輯簡報。無需 Office 互通功能。IRONPPT
- - 支援 125 種語言的 OCR(從圖像中擷取文字)。IRONOCR
- - 讀取與寫入 QR 碼及 BARCODE。IRONBARCODE
- - 讀取與寫入 QR 碼。IRONQR
- - ZIP及解壓縮檔案。IRONZIP
- - 在 .NET 應用程式中列印文件。IRONPRINT
- - 從網站擷取結構化資料。IRONWEBSCRAPER
準備好開始了嗎?
Nuget Downloads 2,374,718|版本:2026.11剛剛發布
您所需的Excel API,沒有Office互通的煩惱。








