Class ExcelTextProperties¶

Namespace: OfficeOpenXml.Data.Connection
Assembly: EPPlus.dll

Properties for text file connections.

public class ExcelTextProperties

Inheritance¶

object ← ExcelTextProperties

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelTextProperties()¶

public ExcelTextProperties()

Properties¶

CharacterSet¶

The character set assosiated with the source file. Names are limited to the IANA charcter set, http://www.iana.org/assignments/character-sets.

public string CharacterSet { get; set; }

Property Value¶

string

Comma¶

Indicates if comma is a delimiter. Defaults to false.

public bool Comma { get; set; }

Property Value¶

bool

Consecutive¶

Indicates if consecutive delimiters are treated as one. Defaults to false.

public bool Consecutive { get; set; }

Property Value¶

bool

Decimal¶

The decimal separator. Defaults to ".".

public string Decimal { get; set; }

Property Value¶

string

Delimited¶

Indicates whether the file is delimited. Defaults to true.

public bool Delimited { get; set; }

Property Value¶

bool

Delimiter¶

The custom delimiter. Optional.

public string Delimiter { get; set; }

Property Value¶

string

Fields¶

Fields describing the text fields data type and position.

public List<ExcelConnectionTextField> Fields { get; }

Property Value¶

List<ExcelConnectionTextField>

FileType¶

Specifies the file type. Defaults to "Win".

public eConnectionTextFileType FileType { get; set; }

Property Value¶

eConnectionTextFileType

FirstRow¶

The first row to read. Defaults to 1.

public uint FirstRow { get; set; }

Property Value¶

uint

Prompt¶

Indicates whether to prompt the user. Defaults to true.

public bool Prompt { get; set; }

Property Value¶

bool

Qualifier¶

The text qualifier used. Defaults to double quote.

public eConnectionTextQualifier Qualifier { get; set; }

Property Value¶

eConnectionTextQualifier

Semicolon¶

Indicates if semicolon is a delimiter. Defaults to false.

public bool Semicolon { get; set; }

Property Value¶

bool

SourceFile¶

The source file path. Defaults to an empty string.

public string SourceFile { get; set; }

Property Value¶

string

Space¶

Indicates if space is a delimiter. Defaults to false.

public bool Space { get; set; }

Property Value¶

bool

Tab¶

Indicates if tab is a delimiter. Defaults to true.

public bool Tab { get; set; }

Property Value¶

bool

Thousands¶

The thousands separator. Defaults to ",".

public string Thousands { get; set; }

Property Value¶

string