导出 Excel 为 CSV、XML、HTML、XLSX

VB C#

using IronXL;

// Create new Excel WorkBook document
WorkBook workBook = WorkBook.Create();

// Create a blank WorkSheet
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");

// Add data and styles to the new worksheet
workSheet["A1"].Value = "Hello World";
workSheet["A2"].Style.BottomBorder.SetColor("#ff6600");

// Save the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML, HTML
workBook.SaveAs("sample.xls");
workBook.SaveAs("sample.xlsx");
workBook.SaveAs("sample.tsv");

// Save the excel file as CSV
workBook.SaveAsCsv("sample.csv");

// Save the excel file as JSON
workBook.SaveAsJson("sample.json");

// Save the excel file 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 a blank WorkSheet
Private workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")

' Add data and styles to the new worksheet
Private workSheet("A1").Value = "Hello World"
workSheet("A2").Style.BottomBorder.SetColor("#ff6600")

' Save the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML, HTML
workBook.SaveAs("sample.xls")
workBook.SaveAs("sample.xlsx")
workBook.SaveAs("sample.tsv")

' Save the excel file as CSV
workBook.SaveAsCsv("sample.csv")

' Save the excel file as JSON
workBook.SaveAsJson("sample.json")

' Save the excel file as XML
workBook.SaveAsXml("sample.xml")

' Export the excel file as HTML
workBook.ExportToHtml("sample.html")

Install-Package IronXL.Excel

导出 Excel 为 CSV、XML、HTML、XLSX

IronXL库可用于从XLS和XLSX格式创建Excel文档。使用IronXL直观的API填充您的工作簿，并使用SaveAs方法将其保存为XLS、XLSX、XLSM、CSV、TSV、JSON、XML或HTML。使用IronXL也可以导出诸如HTML字符串、二进制、字节数组、数据集和内存流等代码数据类型。

尽管SaveAs可用于导出CSV、JSON、XML和HTML。对于每种文件格式，推荐使用独有的方法：

保存为 Csv
保存为Json
另存为Xml
ExportToHtml
请注意，对于CSV、TSV、JSON和XML文件格式，每个工作表都将创建相应的文件。命名规则将为 fileName.sheetName.format。在上面的例子中，CSV格式的输出将是sample.new_sheet.csv。