New to Telerik Document ProcessingStart a free 30-day trial

Base class for text-based workbook format providers that handle delimited value formats like CSV and tab-delimited files, providing common import and export functionality.

Definition

Constructors

Initializes a new instance of the DelimitedValuesFormatProviderBase class with TrimLeadingEmptyRowsAndColumns set to true.

C#
protected DelimitedValuesFormatProviderBase()

Methods

Serializes the active worksheet to delimited text format with cancellation support, applying cell formatting to generate text representations of cell values.

C#
protected override void ExportOverride(Workbook workbook, Stream output, CancellationToken cancellationToken)
Parameters:workbookWorkbook

The workbook.

outputStream

The output.

cancellationTokenCancellationToken

The token used to cancel the operation.

Overrides: WorkbookFormatProviderBase.ExportOverride(Workbook, Stream, CancellationToken)

Parses delimited text from the input stream with cancellation support and returns a workbook with cell values and formatting inferred from the text data.

C#
protected override Workbook ImportOverride(Stream input, CancellationToken cancellationToken)
Parameters:inputStream

The input.

cancellationTokenCancellationToken

The token used to cancel the operation.

Returns:

Workbook

The imported workbook.

Overrides: WorkbookFormatProviderBase.ImportOverride(Stream, CancellationToken)

Properties

Gets a value indicating whether this provider supports exporting workbooks to delimited text format, always returning true.

C#
public override bool CanExport { get; }
Property Value:

The value indicating whether can export.

Overrides: WorkbookFormatProviderBase.CanExport

Gets a value indicating whether this provider supports importing delimited text files, always returning true.

C#
public override bool CanImport { get; }
Property Value:

The value indicating whether can import.

Overrides: WorkbookFormatProviderBase.CanImport

Gets the configuration settings controlling delimiter, quote, encoding, and header behavior for delimited text import and export.

C#
public abstract CsvSettings Settings { get; }
Property Value:

The settings.

Gets or sets a value indicating whether empty rows and columns at the start of the worksheet are excluded from export, defaulting to true to minimize file size.

C#
public bool TrimLeadingEmptyRowsAndColumns { get; set; }
Property Value:

The value indicating whether the leading empty rows and columns should be trimmed.