转换电子表格文件类型

VBC#

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()

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

转换电子表格文件类型

IronXL 为开发人员提供了一种简单灵活的方式来处理 Excel 文件，可以轻松导入和导出各种格式的文件。它支持的文件类型包括HTML，使其成为满足不同应用需求的理想选择。开发人员只需几行代码即可将 Excel 数据转换为适合 Web 集成、API 或进一步数据处理的格式。

例如，将 Excel 文件导出为 HTML 或 JSON 格式，可以轻松地将数据嵌入到 Web 应用程序中；而将其转换为二进制、字节数组或流，则有助于与数据库或其他系统集成。将Excel内容转换为DataSet简化了与SQL数据库的连接或填充像数据网格这样的UI组件。这减少了手动编码，提高了生产力，使 IronXL 成为现代数据驱动型应用程序的宝贵工具。