Class DataTableFormatProviderExportSettings

Configures export behavior from worksheet to DataTable, including header handling, type conversion, and culture settings.

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

Constructors

DataTableFormatProviderExportSettings()

Initializes a new instance of the DataTableFormatProviderExportSettings class with default settings.

Declaration
public DataTableFormatProviderExportSettings()

Properties

DataTableCulture

Gets or sets the culture used for the exported DataTable; defaults to the workbook's culture.

Declaration
public CultureInfo DataTableCulture { get; set; }
Property Value
System.Globalization.CultureInfo

HasHeaderRow

Gets or sets whether the first row of the worksheet should be treated as column headers during export; defaults to true.

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

RangeToExport

Gets or sets the cell range to export; when null, exports the worksheet's used range.

Declaration
public CellRange RangeToExport { get; set; }
Property Value
CellRange

ShouldSetDataTypes

Gets or sets whether to infer and apply strong data types to DataTable columns from cell values; when false, all columns use object type.

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

Methods

OnColumnExporting(DataColumn, Int32)

Raises the ColumnExporting event for the specified column.

Declaration
protected virtual void OnColumnExporting(DataColumn dataColumn, int columnIndex)
Parameters
System.Data.DataColumn dataColumn

The currently exported DataColumn
System.Int32 columnIndex

The index of the column in the DataTable that the event occurs for.

Events

ColumnExporting

Raised for each column during export, allowing customization of column properties before the DataTable is finalized.

Declaration
public event EventHandler<ColumnExportingEventArgs> ColumnExporting
Event Type
System.EventHandler<ColumnExportingEventArgs>