Class

DataTableFormatProviderExportSettings

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

Declaration

public DataTableFormatProviderExportSettings()

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

Declaration

public CultureInfo DataTableCulture { get; set; }

Property Value

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

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

Declaration

public CellRange RangeToExport { get; set; }

Property Value

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

Raises the ColumnExporting event for the specified column.

Declaration

protected virtual void OnColumnExporting(DataColumn dataColumn, int columnIndex)

Parameters

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

Declaration

public event EventHandler<ColumnExportingEventArgs> ColumnExporting

Event Value