TxtDocumentImporterOptions Properties

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

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.