如何儲存或匯出試算表
This article was translated from English: Does it need improvement?
TranslatedView the article in English
DataSet 類別，整合到 Microsoft 的 .NET 中，是 ADO.NET 的基本組成部分。(.NET ActiveX數據對象)科技。 它在與資料庫相關的應用程式中扮演著至關重要的角色，並提供與來自不同來源的資料互動的能力，包括資料庫、XML等。
IronXL 可以將 Excel 工作簿轉換成許多不同的檔案格式以及內嵌代碼對象。 檔案格式包括 XLS、XLSX、XLSM、CSV、TSV、JSON、XML 和 HTML。 內聯代碼對象包括將Excel文件導出為HTML字符串、二進制、字節數組、數據集和流。
開始使用IronXL
立即在您的專案中使用IronXL，並享受免費試用。
匯出試算表範例
編輯或查看工作簿完成後，使用 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.csusing 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")VB C#
匯出 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.csusing 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")VB C#
請注意，對於 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.csusing 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 EFImports 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 EFVB C#
