[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Collapse]Reporting
 [Expand]Product Information
 [Expand]Get Started with DevExpress Reporting
 [Expand]Create Popular Reports
 [Expand]Detailed Guide to DevExpress Reporting
 [Collapse]Visual Studio Report Designer
  [Expand]Dock Panels and Designer Options
  [Expand]Report Wizard
  [Collapse]Data Source Wizard
   [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]Connect to a JSON Data Source
   [Expand]Connect to an XPO Data Source
   [Expand]Connect to a Federated Data Source
    No Data
   Query Builder
 [Expand]Create End-User Reporting Applications
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

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.

Is this topic helpful?​​​​​​​