skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • AI Coding Assistants
    • Embedded Reporting
    • Document Processing Libraries
    • SSO Account Sign-in

    Web

    Kendo UI UI for Angular UI for Vue UI for jQuery KendoReact UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Telerik JustMock

    CMS

    Sitefinity

    AI Productivity Tools

    AI Coding Assistants

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    KendoReact Free VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
    • Roadmap
    • Release History
  • Docs & Support
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

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.

Inheritance
System.Object
WorkbookFormatProviderBase
TextBasedWorkbookFormatProviderBase
DelimitedValuesFormatProviderBase
CsvFormatProvider
TxtFormatProvider
Inherited Members
TextBasedWorkbookFormatProviderBase.Import(String)
TextBasedWorkbookFormatProviderBase.Import(String, Nullable<TimeSpan>)
TextBasedWorkbookFormatProviderBase.Export(Workbook)
TextBasedWorkbookFormatProviderBase.Export(Workbook, Nullable<TimeSpan>)
WorkbookFormatProviderBase.Import(Stream)
WorkbookFormatProviderBase.Import(Stream, Nullable<TimeSpan>)
WorkbookFormatProviderBase.Export(Workbook, Stream)
WorkbookFormatProviderBase.Export(Workbook, Stream, Nullable<TimeSpan>)
WorkbookFormatProviderBase.Name
WorkbookFormatProviderBase.FilesDescription
WorkbookFormatProviderBase.SupportedExtensions
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.FormatProviders.TextBased
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public abstract class DelimitedValuesFormatProviderBase : TextBasedWorkbookFormatProviderBase, ITextBasedWorkbookFormatProvider, IWorkbookFormatProvider

Constructors

DelimitedValuesFormatProviderBase()

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

Declaration
protected DelimitedValuesFormatProviderBase()

Properties

CanExport

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

Declaration
public override bool CanExport { get; }
Property Value
System.Boolean

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
public override bool CanImport { get; }
Property Value
System.Boolean

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
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
public bool TrimLeadingEmptyRowsAndColumns { get; set; }
Property Value
System.Boolean

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
[Obsolete("Use ExportOverride(Workbook workbook, Stream output, CancellationToken cancellationToken) instead.")]
protected override void ExportOverride(Workbook workbook, Stream output)
Parameters
Workbook workbook

The workbook.

System.IO.Stream output

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
protected override void ExportOverride(Workbook workbook, Stream output, CancellationToken cancellationToken)
Parameters
Workbook workbook

The workbook.

System.IO.Stream output

The output.

System.Threading.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
[Obsolete("Use ImportOverride(Stream input, CancellationToken cancellationToken) instead.")]
protected override Workbook ImportOverride(Stream input)
Parameters
System.IO.Stream input

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
protected override Workbook ImportOverride(Stream input, CancellationToken cancellationToken)
Parameters
System.IO.Stream input

The input.

System.Threading.CancellationToken cancellationToken

The token used to cancel the operation.

Returns
Workbook

The imported workbook.

Overrides
WorkbookFormatProviderBase.ImportOverride(Stream, CancellationToken)
Getting Started
  • Getting Started
Support Resources
  • Documentation
Community
  • Forums
  • Blogs
  • Document Processing Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.