如何保存或导出电子表格
集成到 Microsoft .NET 中的 DataSet 类是 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 文件格式,将为每个工作表创建一个单独的文件。命名惯例为 文件名.工作表名.格式。请看下图,其中为 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