Skip to main content

TxtDocumentImporterOptions Members

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

Constructors

Name Description
TxtDocumentImporterOptions() Initializes a new instance of the TxtDocumentImporterOptions 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 text 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 imported text document.
MaxRowCountToAutoDetectDelimiter Gets or sets the number of rows that should be analyzed to automatically detect the character separating values in the text 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 to which text data are imported.

Methods

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 TxtDocumentImporterOptions 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