devexpress-examples / how-to-export-cell-range-to-a-datatable-e4997

Export a cell range to a System.Data.DataTable object.

How to Export a Cell Range from a Spreadsheet Document to a DataTable

This example illustrates how you can export a cell range to a System.Data.DataTable object.

Use the Worksheet.CreateDataTableExporter method to create a DataTableExporter instance and call the DataTableExporter's Export method.

You can use the Worksheet.CreateDataTable method to create an empty DataTable from a cell range. This method obtains column names from the range headings, and determines the column data types based on the first row of the specified range.

Note: Add a reference to the DevExpress.Docs assembly to your Spreadsheet project. The distribution of this assembly requires a license to the DevExpress Office File API or DevExpress Universal Subscription.

Files to Look At

• Form1.cs (VB: Form1.vb)

Documentation

• Import and Export Spreadsheet Data