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. |
| DetectEncoding | Specifies whether or not the character encoding is automatically determined for an imported CSV file. |
| DetectNewlineType | Specifies whether or not a character type used to identify a new line in a CSV document is determined automatically. |
| DetectValueSeparator | Specifies whether or not a character used to separate values in a CSV document is determined automatically. |
| Encoding | Specifies the character encoding of a CSV document. |
| NewlineType | Specifies the character used to identify a new line in a CSV document. |
| SkipEmptyRows | Specifies whether or not to include empty rows into the resulting Excel data source. Inherited from ExcelSourceOptionsBaseViewModel. |
| SkipHiddenColumns | Specifies whether or not to ignore hidden columns when importing data to an Excel data source. |
| SkipHiddenRows | Specifies whether or not to ignore hidden rows when importing data to an Excel data source. |
| TextQualifier | Specifies the character that encloses values in a CSV document. |
| TrimBlanks | Specifies whether or not to remove all leading and trailing white-space characters from each value in a CSV document. |
| UseFirstRowAsHeader | Specifies whether or not to process the values of the first row as headers. Inherited from ExcelSourceOptionsBaseViewModel. |
| ValueSeparator | Specifies a character used to separate values in a CSV document. |
See Also