Class ExcelOutputTextFormat

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

Inheritance
System.Object
ExcelTextFileFormat
ExcelTextFormatBase
ExcelOutputTextFormat
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 ExcelOutputTextFormat : ExcelTextFormatBase

Constructors

ExcelOutputTextFormat()

Describes how to split a CSV text

Default values

Property-Value

Declaration
public ExcelOutputTextFormat()

Properties

DataIsTransposed

Set if data in worksheet is transposed.

Declaration
public bool DataIsTransposed { get; set; }
Property Value
Type Description
System.Boolean

DecimalSeparator

Decimal separator, if other than the used culture.

Declaration
public string DecimalSeparator { get; set; }
Property Value
Type Description
System.String

EncodedTextQualifiers

What to replace Text Qualifiers inside a text, when String Qualifiers is set. Default is two Text Qualifiers characters. For example " is replaced with "".

Declaration
public string EncodedTextQualifiers { get; set; }
Property Value
Type Description
System.String

A text written at the end of the file

Declaration
public string Footer { get; set; }
Property Value
Type Description
System.String

Formats

A specific .NET format for the column. Format is applied with the used culture. For a text column use $ as format

Declaration
public string[] Formats { get; set; }
Property Value
Type Description
System.String[]

Header

A text written at the start of the file.

Declaration
public string Header { get; set; }
Property Value
Type Description
System.String

ThousandsSeparator

Thousands separator, if other than the used culture.

Declaration
public string ThousandsSeparator { get; set; }
Property Value
Type Description
System.String

UseCellFormat

Use the cells Text property with the applied culture. This only applies to columns with no format set in the Formats collection. If SkipLinesBeginning is larger than zero, headers will still be read from the first row in the range. If a TextQualifier is set, non numeric and date columns will be wrapped with the TextQualifier

Declaration
public bool UseCellFormat { get; set; }
Property Value
Type Description
System.Boolean