Class ExcelTextFormat

Describes how to split a CSV text. Used by the ExcelRange.LoadFromText method

Inheritance

System.Object

ExcelTextFormat

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

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

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

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Experior.Core.Data.OfficeOpenXml

Assembly: Experior.Core.dll

Syntax

public class ExcelTextFormat

Constructors

ExcelTextFormat()

Describes how to split a CSV text

Default values

Property-Value

Declaration

public ExcelTextFormat()

Properties

Culture

Culture used when parsing. Default CultureInfo.InvariantCulture

Declaration

public CultureInfo Culture { get; set; }

Property Value

Type	Description
System.Globalization.CultureInfo

DataTypes

Datatypes list for each column (if column is not present Unknown is assumed)

Declaration

public eDataTypes[] DataTypes { get; set; }

Property Value

Type	Description
eDataTypes[]

Delimiter

Delimiter character

Declaration

public char Delimiter { get; set; }

Property Value

Type	Description
System.Char

Encoding

Only used when reading 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 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

TextBlock qualifier character

Declaration

public char TextQualifier { get; set; }

Property Value

Type	Description
System.Char