Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Collapse]DevExpress.Xpf.DataAccess.DataSourceWizard
   [Expand]ChooseConnectionPage Class
   [Expand]ChooseDataSourceNamePage Class
   [Expand]ChooseDataSourceTypePage Class
   [Expand]ChooseEFConnectionStringPage Class
   [Expand]ChooseEFContextPage Class
   [Expand]ChooseEFDataMemberPage Class
   [Expand]ChooseExcelFileDataRangePage Class
   [Expand]ChooseFileOptionsPage Class
   [Expand]ChooseFilePage Class
   [Expand]ChooseObjectAssemblyPage Class
   [Expand]ChooseObjectBindingModePage Class
   [Expand]ChooseObjectConstructorPage Class
   [Expand]ChooseObjectMemberPage Class
   [Expand]ChooseObjectTypePage Class
   [Expand]ConfigureEFConnectionStringPage Class
   [Expand]ConfigureEFFiltersPage Class
   [Expand]ConfigureEFStoredProceduresPage Class
   [Expand]ConfigureExcelFileColumnsPage Class
   [Expand]ConfigureParametersPage Class
   [Expand]ConfigureQueryPage Class
   [Expand]ConnectionPropertiesPage Class
   [Expand]DataSourceWizardCustomizationModel Class
    EFDataMemberType Enumeration
   [Expand]EFDataMemberViewModelBase Class
   [Expand]EFDBStoredProcedureViewModel Class
   [Expand]EFDBTableViewModel Class
   [Expand]EntryBase Class
   [Expand]ExcelSourceOptionsBaseViewModel Class
   [Collapse]ExcelSourceOptionsViewModel Class
     ExcelSourceOptionsViewModel Members
    [Collapse]ExcelSourceOptionsViewModel Properties
      Culture Property
      DetectEncoding Property
      DetectNewlineType Property
      DetectValueSeparator Property
      Encoding Property
      NewlineType Property
      SkipHiddenColumns Property
      SkipHiddenRows Property
      TextQualifier Property
      TrimBlanks Property
      ValueSeparator Property
    [Expand]ExcelSourceOptionsViewModel Methods
   [Expand]FieldInfoViewModel Class
   [Expand]IDataSourceWizardCustomizationService Interface
   [Expand]MultiQueryConfigurePage Class
   [Expand]MultiQueryConfigureParametersPage Class
   [Expand]ObjectConstructorParametersPage Class
   [Expand]ObjectMemberParametersPage Class
   [Expand]ParametersPageBase Class
   [Expand]ParameterViewModel Class
   [Expand]QueryParameterViewModel Class
   [Expand]SaveConnectionPage Class
   [Expand]ValueSeparator Class
   [Expand]ViewModelSourceIntegrityContainer Class
   [Expand]WizardPageBase Class
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Expand]DevExpress.Xpf.PivotGrid
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.SpellChecker
  [Expand]DevExpress.Xpf.Spreadsheet
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

ExcelSourceOptionsViewModel Properties

A ViewModel that defines the settings of an Excel Data Source.

Expanded Public Properties

Show: Inherited
  Name Description
Public property Culture Specifies the culture information used to parse the data being imported from a CSV file.
Public property DetectEncoding Specifies whether or not the character encoding is automatically determined for an imported CSV file.
Public property DetectNewlineType Specifies whether or not a character type used to identify a new line in a CSV document is determined automatically.
Public property DetectValueSeparator Specifies whether or not a character used to separate values in a CSV document is determined automatically.
Public property Encoding Specifies the character encoding of a CSV document.
Public property NewlineType Specifies the character used to identify a new line in a CSV document.
Public property SkipEmptyRows Specifies whether or not to include empty rows into the resulting Excel data source. (Inherited from ExcelSourceOptionsBaseViewModel)
Public property SkipHiddenColumns Specifies whether or not to ignore hidden columns when importing data to an Excel data source.
Public property SkipHiddenRows Specifies whether or not to ignore hidden rows when importing data to an Excel data source.
Public property TextQualifier Specifies the character that encloses values in a CSV document.
Public property TrimBlanks Specifies whether or not to remove all leading and trailing white-space characters from each value in a CSV document.
Public property UseFirstRowAsHeader Specifies whether or not to process the values of the first row as headers. (Inherited from ExcelSourceOptionsBaseViewModel)
Public property ValueSeparator Specifies a character used to separate values in a CSV document.
Top

Expanded See Also

How would you rate this topic?​​​​​​​