New to Telerik Document Processing? Start a free 30-day trial

DataTableFormatProviderExportSettings

Class

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

Definition

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class DataTableFormatProviderExportSettings

Inheritance: objectDataTableFormatProviderExportSettings

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

public DataTableFormatProviderExportSettings()

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

public event EventHandler<ColumnExportingEventArgs> ColumnExporting

Raises the ColumnExporting event for the specified column.

protected virtual void OnColumnExporting(DataColumn dataColumn, int columnIndex)

Parameters:dataColumnDataColumn

The currently exported DataColumn

columnIndexint

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

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; }