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.

Import Settings for an Excel Workbook

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

ExcelDataSource_SpecifyingImportOptions

  • 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.

Import Settings for a CSV file

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

ExcelDataSource_CsvImportSettings

  • 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.