Export data

Export data from a spreadsheet

From the Cells property (ExcelRange) you can access these methods to write:

• ToText and ToTextAsync - Writes a range to a string in a text file format like csv or tsv.

• SaveToText and SaveToTextAsync - Writes a range to a text file like csv or tsv.

• ToDataTable - Exports data from a range to a System.Data.DataTable

• ToCollection - Exports data from a range to an IEnumerable<T> where T is a class.

• ToJson - Exports data from a range to Json.

• CreateHtmlExporter - Exports data from a range to html/css.

• GetValue<T> - Gets a value, with the option to specify a datatype

• Value - Gets or sets the value of the range.

See also

• Sample 2 - C# or Sample 2 - VB.
• Import/Export data overview