Class ExcelOutputTextFormatFixedWidth¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Describes how to output an fixed width text file.

public class ExcelOutputTextFormatFixedWidth : ExcelTextFormatFixedWidthBase

Inheritance¶

object ← ExcelTextFileFormat ← ExcelTextFormatFixedWidthBase ← ExcelOutputTextFormatFixedWidth

Inherited Members¶

ExcelTextFileFormat.Culture
ExcelTextFileFormat.Encoding
ExcelTextFileFormat.EOL
ExcelTextFileFormat.FirstRowIsHeader
ExcelTextFileFormat.ShouldUseRow
ExcelTextFileFormat.SkipLinesBeginning
ExcelTextFileFormat.SkipLinesEnd
ExcelTextFileFormat.TableStyle
ExcelTextFileFormat.Transpose
ExcelTextFormatFixedWidthBase.ClearColumnFormats()
ExcelTextFormatFixedWidthBase.Columns
ExcelTextFormatFixedWidthBase.FormatErrorStrategy
ExcelTextFormatFixedWidthBase.LineLength
ExcelTextFormatFixedWidthBase.PaddingCharacter
ExcelTextFormatFixedWidthBase.PaddingCharacterNumeric
ExcelTextFormatFixedWidthBase.SetColumnDataTypes(params eDataTypes[])
ExcelTextFormatFixedWidthBase.SetColumnLengths(params int[])
ExcelTextFormatFixedWidthBase.SetColumnPaddingAlignmentType(params PaddingAlignmentType[])
ExcelTextFormatFixedWidthBase.SetColumnPositions(int, params int[])
ExcelTextFormatFixedWidthBase.SetColumnsNames(params string[])
ExcelTextFormatFixedWidthBase.SetUseColumns(params bool[])
object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelOutputTextFormatFixedWidth()¶

Describes how to split a fixed width text

public ExcelOutputTextFormatFixedWidth()

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

ExcludeHeader¶

Flag to exclude header for fixed width text file

public bool ExcludeHeader { 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

UseTrailingMinus¶

Set this to output file with trailing minus signs.

public bool UseTrailingMinus { get; set; }

Property Value¶

bool