如何儲存或匯出試算表
DataSet 類別,整合到 Microsoft 的 .NET 中,是 ADO.NET 的基本組成部分。 (.NET ActiveX數據對象) 技術在與資料庫相關的應用中發揮著至關重要的作用,並提供了從多種來源(包括資料庫、XML 等)互動的功能。
IronXL 可以將 Excel 活頁簿轉換為多種不同的檔案格式以及內嵌代碼對象。檔案格式包括 XLS、XLSX、XLSM、CSV、TSV、JSON、XML 和 HTML。內嵌代碼對象則包括將 Excel 檔案匯出為 HTML 字串、二進制、位元組陣列、資料集和流。
立即開始在您的專案中使用IronPDF,並享受免費試用。
查看 IronXL 上 Nuget 快速安裝和部署。已被下載超過800萬次,它正用C#改變Excel。
Install-Package IronXL.Excel
請考慮安裝 IronXL DLL 直接下載並手動安裝到您的專案或GAC表單: IronXL.zip
手動安裝到您的項目中
下載DLL匯出試算表範例
編輯或查看工作簿完成後,使用 SaveAs
方法將 Excel 試算表匯出到所需的文件格式。此方法支持多種類型的文件格式,例如 XLS、XLSX、XLSM、CSV、TSV、JSON、XML 和 HTML。
匯入或匯出時不要忘記包含文件擴展名。默認情況下,新建的 Excel 文件將創建在項目的 'bin > Debug > net6.0' 文件夾中。
:path=/static-assets/excel/content-code-examples/how-to/export-spreadsheet-export-spreadsheet.cs
using IronXL;
// Create new Excel WorkBook document
WorkBook workBook = WorkBook.Create();
// Create a blank WorkSheet
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");
// Save the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML, HTML
workBook.SaveAs("sample.xls");
Imports IronXL
' Create new Excel WorkBook document
Private workBook As WorkBook = WorkBook.Create()
' Create a blank WorkSheet
Private workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")
' Save the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML, HTML
workBook.SaveAs("sample.xls")
匯出 CSV、JSON、XML 和 HTML 文件
雖然可以使用 SaveAs
方法來匯出 CSV、JSON、XML 和 HTML 文件,但建議針對每種文件格式使用專屬的方法。請使用 SaveAsCsv
、SaveAsJson
、SaveAsXml
和 ExportToHtml
方法。
:path=/static-assets/excel/content-code-examples/how-to/export-spreadsheet-export-csv-json-xml-html.cs
using IronXL;
// Create new Excel WorkBook document
WorkBook workBook = WorkBook.Create();
// Create three WorkSheets
WorkSheet workSheet1 = workBook.CreateWorkSheet("sheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("sheet2");
// Input information
workSheet1["A1"].StringValue = "A1";
workSheet2["A1"].StringValue = "A1";
// Save as CSV
workBook.SaveAsCsv("sample.csv");
// Save as JSON
workBook.SaveAsJson("sample.json");
// Save as XML
workBook.SaveAsXml("sample.xml");
// Export the excel file as HTML
workBook.ExportToHtml("sample.html");
Imports IronXL
' Create new Excel WorkBook document
Private workBook As WorkBook = WorkBook.Create()
' Create three WorkSheets
Private workSheet1 As WorkSheet = workBook.CreateWorkSheet("sheet1")
Private workSheet2 As WorkSheet = workBook.CreateWorkSheet("sheet2")
' Input information
Private workSheet1("A1").StringValue = "A1"
Private workSheet2("A1").StringValue = "A1"
' Save as CSV
workBook.SaveAsCsv("sample.csv")
' Save as JSON
workBook.SaveAsJson("sample.json")
' Save as XML
workBook.SaveAsXml("sample.xml")
' Export the excel file as HTML
workBook.ExportToHtml("sample.html")
請注意,對於 CSV、TSV、JSON 和 XML 文件格式,每個工作表將創建一個單獨的文件。命名約定為 fileName.sheetName.format。請查看下圖,其中為 CSV、JSON 和 XML 格式創建了兩個文件。
匯出為內嵌程式碼物件
將 Excel 工作簿匯出為各種內嵌程式碼物件,例如 HTML 字串、二進位數據、位元組數組、串流,甚至是 .NET DataSet。使用相應的方法來實現,並且返回的物件可用於進一步處理。
:path=/static-assets/excel/content-code-examples/how-to/export-spreadsheet-export-object.cs
using IronXL;
using System.IO;
// Create new Excel WorkBook document
WorkBook workBook = WorkBook.Create();
// Create a blank WorkSheet
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");
// Export to HTML string
string htmlString = workBook.ExportToHtmlString();
// Export as Byte array
byte[] binary = workBook.ToBinary();
byte[] byteArray = workBook.ToByteArray();
// Export as Stream
Stream stream = workBook.ToStream();
// Export as DataSet
System.Data.DataSet dataSet = workBook.ToDataSet(); // Allow easy integration with DataGrids, SQL and EF
Imports IronXL
Imports System.IO
' Create new Excel WorkBook document
Private workBook As WorkBook = WorkBook.Create()
' Create a blank WorkSheet
Private workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")
' Export to HTML string
Private htmlString As String = workBook.ExportToHtmlString()
' Export as Byte array
Private binary() As Byte = workBook.ToBinary()
Private byteArray() As Byte = workBook.ToByteArray()
' Export as Stream
Private stream As Stream = workBook.ToStream()
' Export as DataSet
Private dataSet As System.Data.DataSet = workBook.ToDataSet() ' Allow easy integration with DataGrids, SQL and EF