Skip to main content

CsvDocumentImporterOptions Members

Contains options used for loading (importing) a document in CSV format.

Constructors

Name	Description
CsvDocumentImporterOptions()	Initializes a new instance of the CsvDocumentImporterOptions class with the default settings.

Properties

Name	Description
AutoDetectDelimiter	Gets or sets a value indicating whether to automatically detect a character separating values in the CSV file.
AutoDetectEncoding	Gets or sets whether the spreadsheet attempts to detect encoding of the text being imported.
CellIndexOutOfRangeStrategy	Gets or sets the action performed when the spreadsheet cannot assign imported data to a cell.
CellReferenceStyle	Gets or sets the cell reference style used in a source document.
ClearWorksheetBeforeImport	Gets or sets whether to clear a worksheet before importing data.
ColumnTypes	Provides access to the object which enables you to specify the data types for columns in an imported document.
Culture	Gets or sets culture information used to parse imported data.
Delimiter	Gets or sets the character that separates values in the text.
Encoding	Gets or sets the encoding used to interpret characters in the loaded CSV document.
MaxRowCountToAutoDetectDelimiter	Gets or sets the number of rows that should be analyzed to automatically detect the character separating values in the CSV file.
MaxRowCountToImport	Gets or sets the maximum number of rows which will be filled with imported data in the resulting worksheet.
NewlineType	Gets or sets a character sequence used to define a new line.
StartCellToInsert	Gets or sets the upper left cell of the imported data range.
StartRowToImport	Gets or sets the row index of imported data starting from which the data are placed in worksheet cells.
TextQualifier	Gets or sets the character that encloses values in the source text.
TrimBlanks	Gets or sets whether to remove all leading and trailing white-space characters from each imported string value.
ValueTypeDetectMode	Gets or sets the level of complexity to which the type of imported value is recognized.
Worksheet	Gets or sets a destination worksheet into which data is imported.

Name	Description
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.
Clone()	Creates a copy of the current CsvDocumentImporterOptions object.
EndUpdate()	Unlocks the BaseOptions object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from BaseOptions.
Equals(Object, Object) static	Determines 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() protected	Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static	Determines 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

CsvDocumentImporterOptions Class

DevExpress.XtraSpreadsheet.Import Namespace

Was this page helpful?

Thanks for your feedback!

How can we improve this help topic?

Add an example/code snippet.

Improve topic clarity.

Improve organization/make it easier to find.

Include additional information/content.

Additional comments/thoughts:

If you have any questions, submit a ticket to our Support Center.

No

Your feedback is appreciated.