Back to Devexpress

CsvDocumentExporterOptions Members

officefileapi-devexpress-dot-xtraspreadsheet-dot-export-dot-csvdocumentexporteroptions-dot-underscore-members.md

latest7.7 KB
Original Source

CsvDocumentExporterOptions Members

Contains options used for saving (exporting) a document in CSV format.

Constructors

NameDescription
CsvDocumentExporterOptions()Initializes a new instance of the CsvDocumentExporterOptions class with the default settings.

Properties

NameDescription
CellReferenceStyleGets or sets the cell reference style used in a source document.
CultureGets or sets the culture information used to format strings of data.
DiscardTrailingEmptyCellsGets or sets whether empty trailing cells in each row should not be exported.
FormulaExportModeGets or sets how to export cells containing formulas.
NewlineAfterLastRowGets or sets whether the newline character sequence is inserted after the last row of the resulting text.
NewlineTypeGets or sets a character sequence used to define a new line.
QuotationModeGets or sets a value indicating how to quote text values in the exported CSV document.
RangeGets or sets the worksheet range for export.
RepeatMergedCellValuesGets or sets a value indicating whether to repeat a merged cell value for each cell in the merged range when exporting the document.
ShiftTopLeftGets or sets whether to skip the top left empty cells when exporting the worksheet.
SkipHiddenColumnsSpecifies whether to skip hidden columns when a document is exported to CSV.
SkipHiddenRowsSpecifies whether to skip hidden rows when a document is exported to CSV.
TargetUriGets or sets the URI of the document being exported. Inherited from DocumentExporterOptions.
TextQualifierGets or sets the character that encloses values in the resulting text.
UseCellNumberFormatGets or sets whether to use the cell Formatting.NumberFormat property to convert a cell numeric value to a string.
ValueSeparatorGets or sets a character used to separate values in the resulting text.
WorksheetGets or sets a destination worksheet to which text data are exported.
WritePreambleGets or sets whether to write a prefix that is the sequence of bytes that specifies the encoding used.

Methods

NameDescription
Assign(BaseOptions)Copies all settings from the options object passed as a parameter. Inherited from BaseOptions.
BeginUpdate()Locks the BaseOptions object by disallowing visual updates until the EndUpdate or CancelUpdate method is called. Inherited from BaseOptions.
CancelUpdate()Unlocks the BaseOptions object after it has been locked by the BeginUpdate method, without causing an immediate visual update. Inherited from BaseOptions.
EndUpdate()Unlocks the BaseOptions object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from BaseOptions.
Equals(Object, Object) staticDetermines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode()Serves as the default hash function. Inherited from Object.
GetType()Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protectedCreates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) staticDetermines whether the specified Object instances are the same instance. Inherited from Object.
ToString()Returns a string representing the currently enabled options. Inherited from BaseOptions.

See Also

CsvDocumentExporterOptions Class

DevExpress.XtraSpreadsheet.Export Namespace