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
-
ExcelOutputTextFormat
- Inherited Members
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
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 String Qualifiers is set. Default is two Text Qualifiers characters. For example " is replaced with "".
public string EncodedTextQualifiers { 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; }