Convert Spreadsheet File Types
The IronXL library can be used to create and export XLSX, XLS, CSV, TSV, JSON and XML documents.
We can also export to System.Data.DataSet and System.Data.DataTable objects for interoperability with SQL.
using IronXL;
//Import any XLSX,XLS, CSV or TSV Spreadsheet.
WorkBook workbook = WorkBook.Load("test.xls");
//Optionally Edit the Spreadsheet
workbook.Metadata.Title = "Import & Export Example";
//Export to many formats with fluent saving
workbook.SaveAs("test.xls");
workbook.SaveAs("export.xlsx");
workbook.SaveAsCsv("export.csv");
workbook.SaveAsJson("export.json");
workbook.SaveAsXml("export.xml");
//Also Export to a DataSet to allow easy integration with DataGrids, SQL and EF
System.Data.DataSet dataSet = workbook.ToDataSet();Imports IronXL
'Import any XLSX,XLS, CSV or TSV Spreadsheet.
Private workbook As WorkBook = WorkBook.Load("test.xls")
'Optionally Edit the Spreadsheet
workbook.Metadata.Title = "Import & Export Example"
'Export to many formats with fluent saving
workbook.SaveAs("test.xls")
workbook.SaveAs("export.xlsx")
workbook.SaveAsCsv("export.csv")
workbook.SaveAsJson("export.json")
workbook.SaveAsXml("export.xml")
'Also Export to a DataSet to allow easy integration with DataGrids, SQL and EF
Dim dataSet As System.Data.DataSet = workbook.ToDataSet()
