ImportOptions Properties

The ImportOptions type exposes the following members.

Properties

	Name	Description
	DateTimeFormat	Format if DateTime values are cast to strings or DateTime objects are parsed from strings. If null or empty, parsing will be tried with 'best effort', according to . See also TemporalCultureInfo
	EnforceDateTimesAsNumbers	If true, date or time values (default format number 14 or 21) will be interpreted as numeric values globally. This option overrules possible column options, defined by AddEnforcedColumn(Int32, ImportOptionsColumnType).
	EnforcedColumnTypes	Type enforcing rules during import for particular columns
	EnforceEmptyValuesAsString	If true, empty cells will be interpreted as type of string with an empty value. If false, the type will be Empty and the value null
	EnforcePhoneticCharacterImport	If true, phonetic characters (like ruby characters / Furigana / Zhuyin fuhao) in strings are added in brackets after the transcribed symbols. By default, phonetic characters are removed from strings.
	EnforcingStartRowNumber	The row number (zero-based) where enforcing rules are started to be applied. This is, for instance, to prevent enforcing types in a header row. Any enforcing rule is skipped until this row number is reached
	GlobalEnforcingType	Global strategy to handle cell values. The default will not enforce any general casting, beside defined values of , and
	TemporalCultureInfo	Culture info instance, used to parse DateTime or TimeSpan objects from strings. If null, parsing will be tried with 'best effort', according to . See also DateTimeFormat and TimeSpanFormat
	TimeSpanFormat	Format if TimeSpan values are cast to strings

Top

See Also