ClassDataTableFormatProvider
Converts between ADO.NET DataTable instances and spreadsheet workbooks, enabling bidirectional data exchange for tabular data integration.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.FormatProviders
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class DataTableFormatProviderInheritance: objectDataTableFormatProvider
Constructors
DataTableFormatProvider()
Initializes a new instance of the DataTableFormatProvider class with default import and export settings.
Declaration
public DataTableFormatProvider()Properties
ExportSettings
Gets or sets the settings controlling how worksheet data is exported to DataTable.
Declaration
public DataTableFormatProviderExportSettings ExportSettings { get; set; }Property Value
ImportSettings
Gets or sets the settings controlling how DataTable data is imported into worksheets.
Declaration
public DataTableFormatProviderImportSettings ImportSettings { get; set; }Property Value
Methods
Export(Worksheet)
Exports the specified worksheet to a new DataTable, converting cell values and types according to export settings.
Import(DataTable)
Imports the specified DataTable into a new workbook, creating a worksheet with the table data.
Import(DataTable, Worksheet)
Imports the specified DataTable into an existing worksheet, appending data at the configured start position.