Class ExcelOutputTextFormatFixedWidth
- Namespace
- OfficeOpenXml
- Assembly
- EPPlus.dll
Describes how to output an fixed width text file.
public class ExcelOutputTextFormatFixedWidth : ExcelTextFormatFixedWidthBase- Inheritance
-
ExcelOutputTextFormatFixedWidth
- Inherited Members
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
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
ExcludeHeader
Flag to exclude header for fixed width text file
public bool ExcludeHeader { get; set; }Property Value
Footer
A text written at the end of the file
public string Footer { get; set; }Property Value
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
ThousandsSeparator
Thousands separator, if other than the used culture.
public string ThousandsSeparator { get; set; }Property Value
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
UseTrailingMinus
Set this to output file with trailing minus signs.
public bool UseTrailingMinus { get; set; }