 | 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.
|
| EnforceValidColumnDimensions |
If true, invalid column dimensions (larger than MAX_COLUMN_WIDTH or smaller than MIN_COLUMN_WIDTH) will throw an exception on when reading a workbook.
If false, such invalid values will be ignored and set to MAX_COLUMN_WIDTH or MIN_COLUMN_WIDTH. Default is true
|
| EnforceValidRowDimensions |
If true, invalid row dimensions (larger than MAX_ROW_HEIGHT or smaller than MIN_ROW_HEIGHT) will throw an exception on when reading a workbook.
If false, such invalid values will be ignored and set to MAX_ROW_HEIGHT or MIN_ROW_HEIGHT. Default is true
|
| 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
|
TopSee Also 
