Convert Spreadsheet File Types

VB C#

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

Install-Package IronXL.Excel

Convert Spreadsheet File Types

The IronXL library enable a very convenience and safe way to convert from commonly used spreadsheet file format to the require format to be used in the next process of your .Net project. The available formats are shown below:

Load

XLS
XLSX
XLSM
XLTX
CSV
TSV

Export

XLS, XLSX, XLSM, CSV and TSV
JSON
XML
HTML
In code data types:
HTML string
Binary
Byte array
Data set
Memory stream

How to Convert and Export (XLSX, XLS, XLSM, XLTX, CSV) in C

Install C# library to convert Excel file to other file formats
Use WorkBook class to load or create new XLS or XLSX
View, add or modify data in Excel spreadsheet in C#
Utilize methods in WorkBook class to export the spreadsheet
Check the exported file in specified directory

Exporting Excel into System.Data.DataSet and System.Data.DataTable objects allow easy interoperability or integration with DataGrids, SQL and EF.

You can download a file project from this link.