在C#中导出Excel电子表格

VBC#

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
Dim workBook As WorkBook = WorkBook.Create()

' Create a blank WorkSheet
Dim workSheet As 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")

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

在C#中导出Excel电子表格

IronXL 可以轻松地将 Excel 文件保存为不同的格式，使其成为共享和集成数据的实用工具。开发人员可以快速轻松地处理各种报告需求。它无需进行复杂的转换，并支持多种格式。它允许使用最少的代码创建结构良好、样式规范的文件，这些文件可以与许多应用程序兼容。导出为 HTML 或 JSON 等格式还可以简化将 Excel 数据集成到 Web 应用程序和 API 的过程。这简化了流程，节省了时间，并提高了开发人员的工作效率。