Class ExcelOutputTextFormatFixedWidth

Describes how to output an fixed width text file.

Inheritance
System.Object
ExcelTextFileFormat
ExcelTextFormatFixedWidthBase
ExcelOutputTextFormatFixedWidth
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 ExcelOutputTextFormatFixedWidth : ExcelTextFormatFixedWidthBase

Constructors

ExcelOutputTextFormatFixedWidth()

Describes how to split a fixed width text

Declaration
public ExcelOutputTextFormatFixedWidth()

Properties

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 Text 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

ExcludeHeader

Flag to exclude header for fixed width text file

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

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

UseTrailingMinus

Set this to output file with trailing minus signs.

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