Class
DelimitedValuesFormatProviderBase

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

Namespace:Telerik.Windows.Documents.Spreadsheet.FormatProviders.TextBased

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

cs-api-definition
public abstract class DelimitedValuesFormatProviderBase : TextBasedWorkbookFormatProviderBase, ITextBasedWorkbookFormatProvider, IWorkbookFormatProvider

Inheritance: objectWorkbookFormatProviderBaseTextBasedWorkbookFormatProviderBaseDelimitedValuesFormatProviderBase

Derived Classes: CsvFormatProviderTxtFormatProvider

Implements: ITextBasedWorkbookFormatProviderIWorkbookFormatProvider

Inherited Members TextBasedWorkbookFormatProviderBase.Import(string)TextBasedWorkbookFormatProviderBase.Import(string, TimeSpan?)TextBasedWorkbookFormatProviderBase.Export(Workbook)TextBasedWorkbookFormatProviderBase.Export(Workbook, TimeSpan?)WorkbookFormatProviderBase.Import(Stream)WorkbookFormatProviderBase.Import(Stream, TimeSpan?)WorkbookFormatProviderBase.Export(Workbook, Stream)WorkbookFormatProviderBase.Export(Workbook, Stream, TimeSpan?)WorkbookFormatProviderBase.NameWorkbookFormatProviderBase.FilesDescriptionWorkbookFormatProviderBase.SupportedExtensions

Constructors

DelimitedValuesFormatProviderBase()

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

Declaration

cs-api-definition
protected DelimitedValuesFormatProviderBase()

Properties

CanExport

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

Declaration

cs-api-definition
public override bool CanExport { get; }

Property Value

bool

The value indicating whether can export.

Overrides WorkbookFormatProviderBase.CanExport

CanImport

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

Declaration

cs-api-definition
public override bool CanImport { get; }

Property Value

bool

The value indicating whether can import.

Overrides WorkbookFormatProviderBase.CanImport

Settings

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

Declaration

cs-api-definition
public abstract CsvSettings Settings { get; }

Property Value

CsvSettings

The settings.

TrimLeadingEmptyRowsAndColumns

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.

Declaration

cs-api-definition
public bool TrimLeadingEmptyRowsAndColumns { get; set; }

Property Value

bool

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

Methods

ExportOverride(Workbook, Stream)

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

Declaration

cs-api-definition
[Obsolete("Use ExportOverride(Workbook workbook, Stream output, CancellationToken cancellationToken) instead.")]
protected override void ExportOverride(Workbook workbook, Stream output)

Parameters

workbook

Workbook

The workbook.

output

Stream

The output.

Overrides WorkbookFormatProviderBase.ExportOverride(Workbook, Stream)

ExportOverride(Workbook, Stream, CancellationToken)

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

Declaration

cs-api-definition
protected override void ExportOverride(Workbook workbook, Stream output, CancellationToken cancellationToken)

Parameters

workbook

Workbook

The workbook.

output

Stream

The output.

cancellationToken

CancellationToken

The token used to cancel the operation.

Overrides WorkbookFormatProviderBase.ExportOverride(Workbook, Stream, CancellationToken)

ImportOverride(Stream)

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

Declaration

cs-api-definition
[Obsolete("Use ImportOverride(Stream input, CancellationToken cancellationToken) instead.")]
protected override Workbook ImportOverride(Stream input)

Parameters

input

Stream

The input.

Returns

Workbook

The imported workbook.

Overrides WorkbookFormatProviderBase.ImportOverride(Stream)

ImportOverride(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.

Declaration

cs-api-definition
protected override Workbook ImportOverride(Stream input, CancellationToken cancellationToken)

Parameters

input

Stream

The input.

cancellationToken

CancellationToken

The token used to cancel the operation.

Returns

Workbook

The imported workbook.

Overrides WorkbookFormatProviderBase.ImportOverride(Stream, CancellationToken)