[]
Specifies how values are quoted when a workbook is exported as a text file.
Use this enum with ValueQuoteType to control whether values are quoted according to Excel-like rules for special characters, quoted unconditionally, quoted only in minimum cases, or not quoted at all.
public enum ValueQuoteType
Public Enum ValueQuoteType
CsvSaveOptions options = new CsvSaveOptions();
options.ValueQuoteType = ValueQuoteType.Always;
ValueQuoteType quoteType = options.ValueQuoteType;
| Name | Description |
|---|---|
| Always | All values will be quoted always. |
| Minimum | Only quote values when needed. Such as, if one value contains quotation mark but the quotation mark is not at the begin of this value, this value will not be quoted. |
| Never | All values will not be quoted. The exported text file with this type may not be read back correctly because the needed quotation marks being absent. |
| Normal | Quotes values that contain special characters, such as the quotation mark or the separator character. This behavior is consistent with Microsoft Excel text export. |