Documentation

Class DataTableFormatProviderImportSettings

Provides the import settings for the DataTableFormatProvider.

Inheritance
System.Object
DataTableFormatProviderImportSettings
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 DataTableFormatProviderImportSettings

Constructors

DataTableFormatProviderImportSettings()

Initializes an instance of the DataTableFormatProviderImportSettings class.

Declaration
public DataTableFormatProviderImportSettings()

Properties

PreferredDateTimeFormat

Get or sets the default format string when importing DateTime columns.

Declaration
public string PreferredDateTimeFormat { get; set; }
Property Value
System.String

ShouldImportColumnHeaders

Get or sets whether the column headers should be imported.

Declaration
public bool ShouldImportColumnHeaders { get; set; }
Property Value
System.Boolean

StartCellIndex

Get or sets the index where the table should start in the Worksheet.

Declaration
public CellIndex StartCellIndex { get; set; }
Property Value
CellIndex

Methods

OnCellImported(Int32, Int32, Int32, Int32, Worksheet)

This method triggers the CellImported event.

Declaration
protected virtual void OnCellImported(int dataTableRowIndex, int dataTableColumnIndex, int worksheetRowIndex, int worksheetColumnIndex, Worksheet worksheet)
Parameters
System.Int32 dataTableRowIndex

The index of the row in the DataTable containing the cell that the event occurs for.
System.Int32 dataTableColumnIndex

The index of the column in the DataTable containing the cell that the event occurs for.
System.Int32 worksheetRowIndex

The index of the row in the Worksheet containing the cell that the event occurs for.
System.Int32 worksheetColumnIndex

The index of the column in the Worksheet containing the cell that the event occurs for.
Worksheet worksheet

The worksheet where the data is imported.

Events

CellImported

This event is fired for each cell and allows you to change the cell properties.

Declaration
public event EventHandler<CellImportedEventArgs> CellImported
Event Type
System.EventHandler<CellImportedEventArgs>