Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Expand]Controls and Libraries
 [Collapse]Common Features
  [Expand]Data Binding Common Concepts
  [Collapse]Data Source Wizard
   [Collapse]Pages
    [Expand]Start Pages
    [Expand]Connect to a Database
    [Expand]Connect to an Entity Framework Data Source
    [Expand]Connect to an Object Data Source
    [Collapse]Connect to an Excel Data Source
      Select an Excel Workbook or CSV File
      Specify Import Settings
      Select a Worksheet, Table or Named Range
      Choose Columns
   [Expand]Customization API
  [Expand]Expressions
  [Expand]Behaviors
  [Expand]Application Appearance
  [Expand]Filtering UI Context
  [Expand]High DPI Support
  [Expand]Scaffolding Wizard
  [Expand]Formatting Values
   HTML Text Formatting
  [Expand]Menus
  [Expand]Tooltip Management
  [Expand]Saving and Restoring Layouts
   Clipboard - Copy Data and Formatting
   Version Compatibility: Default Property Values
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Specify Import Settings

On this wizard page, you can specify required import settings. This page provides access to different settings depending on whether you have selected an Excel Workbook or CSV file.

Expanded Import Settings for an Excel Workbook

The following settings are available if an Excel workbook has been selected.

  • Use values of the first rows as field names - Specifies whether values of the first row should be imported as field names. If this option is disabled, values of the first row will be imported as data and field names will be generated automatically.
  • Skip empty rows - Specifies whether or not to include empty rows to the resulting data source.
  • Skip hidden rows - Specifies whether or not to include hidden rows to the resulting data source.
  • Skip hidden columns - Specifies whether or not to include hidden columns to the resulting data source.

Click Next to proceed to the next wizard page: Select a Worksheet, Table or Named Range.

Expanded Import Settings for a CSV file

The following settings are available if a CSV file has been selected.

  • Use values of the first rows as field names - Specifies whether or not values of the first row should be imported as field names. If this option is disabled, values of the first row will be imported as data and field names will be generated automatically.
  • Skip empty rows - Specifies whether or not to include empty rows to the resulting data source.
  • Trim Blanks - Specifies whether to delete all leading and trailing empty spaces from each value in the source CSV file.
  • Encoding - Specifies the character encoding in the source CSV file. If the corresponding Detect automatically check box is enabled, this setting's value is automatically determined.
  • Newline type - Specifies the line break type in the source CSV file. If the corresponding Detect automatically check box is enabled, this setting's value is automatically determined.
  • Value separator - Specifies a character used to separate values in the source CSV file. If the corresponding Detect automatically check box is enabled, this setting's value is automatically determined.
  • Culture - Specifies culture information used to import data from the source CSV file.
  • Text Qualifier - Specifies the character that encloses values in the source CSV file.

Click Next to proceed to the next wizard page: Choose Columns.

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