This sample demonstrates exporting data from Excel to a data table, and import data from the data table to the Grid.
The ImportDataTable and ExportDataTable methods makes it easier to work with ADO.NET data tables. It just takes one line of code to import data from data table to a Spreadsheet or export data from Spreadsheet to a data table.
- Usage of helper methods to work with ADO.NET
- Import data from Spreadsheet to a data table
- Export data from data table to Spreadsheet
- Apply row and column styles
- Export data from Spreadsheet to a data table by skipping specific rows, replacing cell values in the data table, and stop exporting