Class ExcelTextFileFormat

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

Inheritance

System.Object

ExcelTextFileFormat

ExcelTextFormatBase

ExcelTextFormatFixedWidthBase

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 abstract class ExcelTextFileFormat

Constructors

ExcelTextFileFormat()

Declaration

public ExcelTextFileFormat()

Properties

Culture

Culture used when parsing. Default CultureInfo.InvariantCulture

Declaration

public CultureInfo Culture { get; set; }

Property Value

Type	Description
System.Globalization.CultureInfo

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

FirstRowIsHeader

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

Declaration

public bool FirstRowIsHeader { get; set; }

Property Value

Type	Description
System.Boolean

ShouldUseRow

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

Declaration

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

Property Value

Type	Description
System.Func<System.String, System.Boolean>

SkipLinesBeginning

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

Declaration

public int SkipLinesBeginning { get; set; }

Property Value

Type	Description
System.Int32

SkipLinesEnd

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

Declaration

public int SkipLinesEnd { get; set; }

Property Value

Type	Description
System.Int32

TableStyle

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

Declaration

public TableStyles? TableStyle { get; set; }

Property Value

Type	Description
System.Nullable<TableStyles>

Transpose

Set if data should be transposed

Declaration

public bool Transpose { get; set; }

Property Value

Type	Description
System.Boolean