Data Management in WPF Spreadsheet (SfSpreadsheet)

23 Jul 20261 minute to read

SfSpreadsheet supports importing and exporting worksheet data to and from a DataTable.

Import from DataTable

SfSpreadsheet provides support to import the data. The following list of data can be imported into the worksheet

  • Data Table
  • Data Column
  • Data View
  • Business Objects
  • Array

To import the data from a data table, you can use ImportDataTable
method

spreadsheet.ActiveSheet.ImportDataTable(data_table, true, 1, 1);
spreadsheet.ActiveGrid.InvalidateCells();

For more details regarding importing data, please refer to the XlsIO UG.

Export to DataTable

SfSpreadsheet provides support to export the data. To Export the data from a data table, you can use ExportDataTable
method

IWorksheet sheet = spreadsheet.Workbook.Worksheets[0];
IRange range = sheet.Range["A1:K50"];
DataTable data_table = sheet.ExportDataTable(range, ExcelExportDataTableOptions.ColumnNames);

For more details regarding exporting data, please refer to the XlsIO UG.

See also