Class ExcelOutputTextFormat¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

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

public class ExcelOutputTextFormat : ExcelTextFormatBase

Inheritance¶

object ← ExcelTextFormatBase ← ExcelOutputTextFormat

Inherited Members¶

ExcelTextFormatBase.Culture
ExcelTextFormatBase.Delimiter
ExcelTextFormatBase.Encoding
ExcelTextFormatBase.EOL
ExcelTextFormatBase.SkipLinesBeginning
ExcelTextFormatBase.SkipLinesEnd
ExcelTextFormatBase.TextQualifier
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelOutputTextFormat()¶

Describes how to split a CSV text

Default values

Property-Value

public ExcelOutputTextFormat()

Properties¶

DecimalSeparator¶

Decimal separator, if other than the used culture.

public string DecimalSeparator { get; set; }

Property Value¶

string

EncodedTextQualifiers¶

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

public string EncodedTextQualifiers { get; set; }

Property Value¶

string

FirstRowIsHeader¶

First row of the range contains the headers. All header cells will be treated as strings.

public bool FirstRowIsHeader { get; set; }

Property Value¶

bool

Footer¶

A text written at the end of the file

public string Footer { get; set; }

Property Value¶

string

Formats¶

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

public string[] Formats { get; set; }

Property Value¶

string[]

Header¶

A text written at the start of the file.

public string Header { get; set; }

Property Value¶

string

ThousandsSeparator¶

Thousands separator, if other than the used culture.

public string ThousandsSeparator { get; set; }

Property Value¶

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

public bool UseCellFormat { get; set; }

Property Value¶

bool