Class ExcelTextFormatBase

Describes how to split a CSV text. Used by the ExcelRange.LoadFromText method. Base class for ExcelTextFormat and ExcelOutputTextFormat ExcelTextFormat ExcelOutputTextFormat

Inheritance

System.Object

ExcelTextFormatBase

ExcelOutputTextFormat

ExcelTextFormat

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public class ExcelTextFormatBase

Constructors

ExcelTextFormatBase()

Creates a new instance if ExcelTextFormatBase

Declaration

public ExcelTextFormatBase()

Properties

Culture

Culture used when parsing. Default CultureInfo.InvariantCulture

Declaration

public CultureInfo Culture { get; set; }

Property Value

Type	Description
System.Globalization.CultureInfo

Delimiter

Delimiter character

Declaration

public char Delimiter { get; set; }

Property Value

Type	Description
System.Char

Encoding

Only used when reading/writing files from disk using a FileInfo object. Default AscII

Declaration

public Encoding Encoding { get; set; }

Property Value

Type	Description
System.Text.Encoding

EOL

End of line characters. Default is CRLF

Declaration

public string EOL { get; set; }

Property Value

Type	Description
System.String

SkipLinesBeginning

Number of lines skiped in the begining of the file. Default 0.

Declaration

public int SkipLinesBeginning { get; set; }

Property Value

Type	Description
System.Int32

SkipLinesEnd

Number of lines skiped at the end of the file. Default 0.

Declaration

public int SkipLinesEnd { get; set; }

Property Value

Type	Description
System.Int32

TextQualifier

Text qualifier character. Default no TextQualifier (\0)

Declaration

public char TextQualifier { get; set; }

Property Value

Type	Description
System.Char