Class ExcelTextFileFormat¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Describes how to split a text file. Used by the ExcelRange.LoadFromText method. Base class for ExcelTextFormatBase, ExcelTextFormatFixedWidthBase ExcelTextFormatBase ExcelTextFormatFixedWidthBase

public abstract class ExcelTextFileFormat

Inheritance¶

object ← ExcelTextFileFormat

Derived¶

ExcelTextFormatBase
ExcelTextFormatFixedWidthBase

Inherited Members¶

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

Constructors¶

ExcelTextFileFormat()¶

public ExcelTextFileFormat()

Properties¶

Culture¶

Culture used when parsing. Default CultureInfo.InvariantCulture

public CultureInfo Culture { get; set; }

Property Value¶

CultureInfo

EOL¶

End of line characters. Default is CRLF

public string EOL { get; set; }

Property Value¶

string

Encoding¶

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

public Encoding Encoding { get; set; }

Property Value¶

Encoding

FirstRowIsHeader¶

The first row used contains the headers. Will be used if the import has a TableStyle?text=TableStyle set.

public bool FirstRowIsHeader { get; set; }

Property Value¶

bool

ShouldUseRow¶

Will be called for each row. Should return true if the row should be used in the export/import, otherwise false

public Func<string, bool> ShouldUseRow { get; set; }

Property Value¶

Func<string, bool>

SkipLinesBeginning¶

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

public int SkipLinesBeginning { get; set; }

Property Value¶

int

SkipLinesEnd¶

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

public int SkipLinesEnd { get; set; }

Property Value¶

int

TableStyle¶

If not null, create a table from the import with this style.

public TableStyles? TableStyle { get; set; }

Property Value¶

TableStyles?

Transpose¶

Set if data should be transposed

public bool Transpose { get; set; }

Property Value¶

bool