Configures export behavior from worksheet to DataTable, including header handling, type conversion, and culture settings.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.FormatProviders
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class DataTableFormatProviderExportSettingsInheritance: objectDataTableFormatProviderExportSettings
Constructors
Initializes a new instance of the DataTableFormatProviderExportSettings class with default settings.
public DataTableFormatProviderExportSettings()Properties
Gets or sets the culture used for the exported DataTable; defaults to the workbook's culture.
public CultureInfo DataTableCulture { get; set; }Gets or sets whether the first row of the worksheet should be treated as column headers during export; defaults to true.
public bool HasHeaderRow { get; set; }Gets or sets the cell range to export; when null, exports the worksheet's used range.
public CellRange RangeToExport { get; set; }Gets or sets whether to infer and apply strong data types to DataTable columns from cell values; when false, all columns use object type.
public bool ShouldSetDataTypes { get; set; }Methods
Raises the ColumnExporting event for the specified column.
protected virtual void OnColumnExporting(DataColumn dataColumn, int columnIndex)The currently exported DataColumn
columnIndexintThe index of the column in the DataTable that the event occurs for.
Events
Raised for each column during export, allowing customization of column properties before the DataTable is finalized.
public event EventHandler<ColumnExportingEventArgs> ColumnExporting