Class DataTableFormatProvider

Format provider to convert from DataTable to Workbook and vice versa.

Inheritance
System.Object
DataTableFormatProvider
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.FormatProviders
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class DataTableFormatProvider

Constructors

DataTableFormatProvider()

Initializes a new instance of the DataTableFormatProvider class with no arguments.

Declaration
public DataTableFormatProvider()

Properties

ExportSettings

Gets or sets the export settings.

Declaration
public DataTableFormatProviderExportSettings ExportSettings { get; set; }
Property Value
DataTableFormatProviderExportSettings

ImportSettings

Gets or sets the import settings.

Declaration
public DataTableFormatProviderImportSettings ImportSettings { get; set; }
Property Value
DataTableFormatProviderImportSettings

Methods

Export(Worksheet)

Converts the passed workbook to a DataTable.

Declaration
public DataTable Export(Worksheet worksheet)
Parameters
Worksheet worksheet

The worksheet for export.
Returns
System.Data.DataTable

the converted DataTable

Import(DataTable)

Converts the passed DataTable to a new Workbook.

Declaration
public Workbook Import(DataTable table)
Parameters
System.Data.DataTable table

The DataTable for import.
Returns
Workbook

the converted new Workbook.

Import(DataTable, Worksheet)

Adds the data to the worksheet passed as parameter.

Declaration
public void Import(DataTable table, Worksheet worksheet)
Parameters
System.Data.DataTable table

The DataTable for import.
Worksheet worksheet

The Worksheet where the data should be added.

Extension Methods