將 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。建議針對每種檔案格式使用專屬方法：

SaveAsCsv
SaveAsJson
SaveAsXml
導出為Html
請注意，對於 CSV、TSV、JSON 和 XML 檔案格式，每個工作表都將分別建立一個檔案。命名慣例為 fileName.sheetName.format。在上面的例子中，CSV格式的輸出將是 sample.new_sheet.csv