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.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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 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