ExcelSourceOptionsViewModel Properties
A ViewModel that defines the settings of an Excel Data Source.
Name | Description |
---|---|
Culture | Specifies the culture information used to parse the data being imported from a CSV file. |
Detect |
Specifies whether the character encoding is automatically determined for an imported CSV file. |
Detect |
Specifies whether a character type used to identify a new line in a CSV document is determined automatically. |
Detect |
Specifies whether a character used to separate values in a CSV document is determined automatically. |
Encoding | Specifies the character encoding of a CSV document. |
Newline |
Specifies the character used to identify a new line in a CSV document. |
Skip |
Specifies whether to include empty rows into the resulting Excel data source.
Inherited from Excel |
Skip |
Specifies whether to ignore hidden columns when importing data to an Excel data source. |
Skip |
Specifies whether to ignore hidden rows when importing data to an Excel data source. |
Text |
Specifies the character that encloses values in a CSV document. |
Trim |
Specifies whether to remove all leading and trailing white-space characters from each value in a CSV document. |
Use |
Specifies whether to process the values of the first row as headers.
Inherited from Excel |
Value |
Specifies a character used to separate values in a CSV document. |
See Also