New to Telerik Document ProcessingStart a free 30-day trial

Configuration for CSV import controlling delimiter, quote character, and text encoding used while streaming worksheet data.

Definition

Namespace:Telerik.Documents.SpreadsheetStreaming.Importers.Csv.Core

Assembly:Telerik.Documents.SpreadsheetStreaming.dll

Syntax:

C#
public class SpreadCsvSettings

Inheritance: objectSpreadCsvSettings

Constructors

Initializes a new instance of the SpreadCsvSettings class with culture-aware defaults. By default, Delimiter is the current culture's list separator, Quote is '"', and Encoding is UTF-8 with BOM (Excel-compatible).

C#
public SpreadCsvSettings()

Properties

Gets or sets the character that separates fields in each record, falling back to the current culture list separator when unset.

C#
public char Delimiter { get; set; }
Property Value:

The delimiter symbol.

Gets or sets the character encoding applied when reading the CSV stream (defaults to Excel's UTF-8 with BOM for compatibility).

C#
public Encoding Encoding { get; set; }
Property Value:

The encoding.

Gets or sets the text qualifier enclosing field values that contain the delimiter or line breaks (defaults to ").

C#
public char Quote { get; set; }
Property Value:

The quote symbol.