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 ← ExcelTextFileFormat ← ExcelTextFormatBase ← ExcelOutputTextFormat

Inherited Members¶

ExcelTextFileFormat.Culture
ExcelTextFileFormat.Encoding
ExcelTextFileFormat.EOL
ExcelTextFileFormat.FirstRowIsHeader
ExcelTextFileFormat.ShouldUseRow
ExcelTextFileFormat.SkipLinesBeginning
ExcelTextFileFormat.SkipLinesEnd
ExcelTextFileFormat.TableStyle
ExcelTextFileFormat.Transpose
ExcelTextFormatBase.DataTypes
ExcelTextFormatBase.Delimiter
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¶

DataIsTransposed¶

Set if data in worksheet is transposed.

public bool DataIsTransposed { get; set; }

Property Value¶

bool

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 String Qualifiers is set. Default is two Text Qualifiers characters. For example " is replaced with "".

public string EncodedTextQualifiers { get; set; }

Property Value¶

string

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