Skip to main content

SpreadsheetCsvImportOptions Properties

Contains options used for loading (importing) a document in CSV format.
Name Description
AllowDrop Gets or sets a value that indicates whether this element can be used as the target of a drag-and-drop operation. Inherited from ContentElement.
AreAnyTouchesCaptured Gets a value that indicates whether at least one touch is captured to this element. Inherited from ContentElement.
AreAnyTouchesCapturedWithin Gets a value that indicates whether at least one touch is captured to this element or to any child elements in its visual tree. Inherited from ContentElement.
AreAnyTouchesDirectlyOver Gets a value that indicates whether at least one touch is pressed over this element. Inherited from ContentElement.
AreAnyTouchesOver Gets a value that indicates whether at least one touch is pressed over this element or any child elements in its visual tree. Inherited from ContentElement.
AutoDetectDelimiter Gets or sets a value indicating whether to automatically detect a character separating values in the CSV file. This is a dependency property.
AutoDetectEncoding Gets or sets whether the spreadsheet attempts to detect encoding of the text being imported. This is a dependency property.
BindingGroup Gets or sets the BindingGroup that is used for the element. Inherited from FrameworkContentElement.
CellIndexOutOfRangeStrategy Gets or sets the action performed when the spreadsheet cannot assign imported data to a cell. This is a dependency property.
CellReferenceStyle Gets or sets the cell reference style used in a source document. This is a dependency property.
ClearWorksheetBeforeImport Gets or sets whether to clear a worksheet before importing data. This is a dependency property.
CommandBindings Gets a collection of CommandBinding objects that are associated with this element. Inherited from ContentElement.
ContextMenu Gets or sets the context menu element that should appear whenever the context menu is requested via user interface (UI) from within this element. Inherited from FrameworkContentElement.
Culture Gets or sets the culture information used to parse the data being imported. This is a dependency property.
Cursor Gets or sets the cursor that displays when the mouse pointer is over this element. Inherited from FrameworkContentElement.
DataContext Gets or sets the data context for an element when it participates in data binding. Inherited from FrameworkContentElement.
DefaultStyleKey protected Gets or sets the key to use to find the style template for this control in themes. Inherited from FrameworkContentElement.
Delimiter Gets or sets the character that separates values in the text. This is a dependency property.
DependencyObjectType Gets the DependencyObjectType that wraps the CLR type of this instance. Inherited from DependencyObject.
Dispatcher Gets the Dispatcher this DispatcherObject is associated with. Inherited from DispatcherObject.
Focusable Gets or sets a value that indicates whether the element can receive focus. Inherited from ContentElement.
FocusVisualStyle Gets or sets an object that enables customization of appearance, effects, or other style characteristics that will apply to this element when it captures keyboard focus. Inherited from FrameworkContentElement.
ForceCursor Gets or sets a value indicating whether this FrameworkContentElement should force the user interface (UI) to render the cursor as declared by this instance’s Cursor property. Inherited from FrameworkContentElement.
HasAnimatedProperties Gets a value that indicates whether this element has any animated properties. Inherited from ContentElement.
InputBindings Gets the collection of input bindings that are associated with this element. Inherited from ContentElement.
InputScope Gets or sets the context for input used by this FrameworkContentElement. Inherited from FrameworkContentElement.
IsEnabled Gets or sets a value that indicates whether this element is enabled in the user interface (UI). Inherited from ContentElement.
IsEnabledCore protected Gets a value that becomes the return value of IsEnabled in derived classes. Inherited from ContentElement.
IsFocused Gets a value that determines whether this element has logical focus. Inherited from ContentElement.
IsInitialized Gets a value indicating whether this element has been initialized, either by being loaded as Extensible Application Markup Language (XAML), or by explicitly having its EndInit() method called. Inherited from FrameworkContentElement.
IsInputMethodEnabled Gets a value that indicates whether an input method system, such as an Input Method Editor (IME), is enabled for processing the input to this element. Inherited from ContentElement.
IsKeyboardFocused Gets a value that indicates whether this element has keyboard focus. Inherited from ContentElement.
IsKeyboardFocusWithin Gets a value that indicates whether keyboard focus is anywhere within the element or child elements. Inherited from ContentElement.
IsLoaded Gets a value indicating whether this element has been loaded for presentation. Inherited from FrameworkContentElement.
IsMouseCaptured Gets a value that indicates whether the mouse is captured by this element. Inherited from ContentElement.
IsMouseCaptureWithin Gets a value that determines whether mouse capture is held by this element or by child elements in its element tree. Inherited from ContentElement.
IsMouseDirectlyOver Gets a value that indicates whether the position of the mouse pointer corresponds to hit test results, which take element compositing into account. Inherited from ContentElement.
IsMouseOver Gets a value that indicates whether the mouse pointer is located over this element (including visual child elements, or its control compositing). Inherited from ContentElement.
IsSealed Gets a value that indicates whether this instance is currently sealed (read-only). Inherited from DependencyObject.
IsStylusCaptured Gets a value that indicates whether the stylus is captured to this element. Inherited from ContentElement.
IsStylusCaptureWithin Gets a value that determines whether stylus capture is held by this element, including child elements and control compositing. Inherited from ContentElement.
IsStylusDirectlyOver Gets a value that indicates whether the stylus position corresponds to hit test results, which take element compositing into account. Inherited from ContentElement.
IsStylusOver Gets a value that indicates whether the stylus is located over this element (including visual child elements). Inherited from ContentElement.
Language Gets or sets localization/globalization language information that applies to an individual element. Inherited from FrameworkContentElement.
MaxRowCountToAutoDetectDelimiter Gets or sets the number of rows that should be analyzed to automatically detect the character separating values in the CSV file. This is a dependency property.
MaxRowCountToImport Gets or sets the maximum number of rows which will be filled with imported data in the resulting worksheet. This is a dependency property.
Name Gets or sets the identifying name of the element. The name provides an instance reference so that programmatic code-behind, such as event handler code, can refer to an element once it is constructed during parsing of XAML. Inherited from FrameworkContentElement.
NewlineType Gets or sets a character sequence used to define a new line. This is a dependency property.
OverridesDefaultStyle Gets or sets a value indicating whether this element incorporates style properties from theme styles. Inherited from FrameworkContentElement.
Parent Gets the parent in the logical tree for this element. Inherited from FrameworkContentElement.
Resources Gets or sets the current locally-defined resource dictionary. Inherited from FrameworkContentElement.
StartCellToInsert Gets or sets the upper left cell of the imported data range. This is a dependency property.
StartRowToImport Gets or sets the row index of imported data starting from which the data are placed in worksheet cells. This is a dependency property.
Style Gets or sets the style to be used by this element. Inherited from FrameworkContentElement.
Tag Gets or sets an arbitrary object value that can be used to store custom information about this element. Inherited from FrameworkContentElement.
TemplatedParent Gets a reference to the template parent of this element. This property is not relevant if the element was not created through a template. Inherited from FrameworkContentElement.
TextQualifier Gets or sets the character that encloses values in the source text. This is a dependency property.
ToolTip Gets or sets the tool-tip object that is displayed for this element in the user interface (UI). Inherited from FrameworkContentElement.
TouchesCaptured Gets all touch devices that are captured to this element. Inherited from ContentElement.
TouchesCapturedWithin Gets all touch devices that are captured to this element or any child elements in its visual tree. Inherited from ContentElement.
TouchesDirectlyOver Gets all touch devices that are over this element. Inherited from ContentElement.
TouchesOver Gets all touch devices that are over this element or any child elements in its visual tree. Inherited from ContentElement.
TrimBlanks Gets or sets whether to remove all leading and trailing white-space characters from each imported string value. This is a dependency property.
ValueTypeDetectMode Gets or sets the level of complexity to which the type of imported value is recognized. This is a dependency property.
WorksheetName Gets or sets a destination worksheet to which text data are imported. This is a dependency property.
See Also