Configures import behavior from DataTable to worksheet, including header handling, date formatting, and start position.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.FormatProviders
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class DataTableFormatProviderImportSettingsInheritance: objectDataTableFormatProviderImportSettings
Constructors
Initializes a new instance of the DataTableFormatProviderImportSettings class with default settings.
public DataTableFormatProviderImportSettings()Events
Raised after each cell is imported, allowing customization of cell properties in the destination worksheet.
public event EventHandler<CellImportedEventArgs> CellImportedMethods
Raises the CellImported event for the specified cell.
protected virtual void OnCellImported(int dataTableRowIndex, int dataTableColumnIndex, int worksheetRowIndex, int worksheetColumnIndex, Worksheet worksheet)The index of the row in the DataTable containing the cell that the event occurs for.
dataTableColumnIndexintThe index of the column in the DataTable containing the cell that the event occurs for.
worksheetRowIndexintThe index of the row in the Worksheet containing the cell that the event occurs for.
worksheetColumnIndexintThe index of the column in the Worksheet containing the cell that the event occurs for.
worksheetWorksheetThe worksheet where the data is imported.
Properties
Gets or sets the format string applied to imported DateTime columns; when null, uses the current culture's short date pattern.
public string PreferredDateTimeFormat { get; set; }Gets or sets whether DataTable column names should be imported as the first row in the worksheet; defaults to true.
public bool ShouldImportColumnHeaders { get; set; }Gets or sets the cell index where the imported data begins in the worksheet; defaults to (0,0).
public CellIndex StartCellIndex { get; set; }