ImpWiz-ASC-Bin-DataSelPage
Use this page to specify a partial file import, and other data handling instructions.
This drop-down list has three options: None, All Files and From 2nd File On. The All Files and From 2nd File On option will enable From/To Column and From/To Row ranges for partial import.
Enter two column numbers to specify the column range for partial import. The default From and To settings are 1 and 0 respectively (which will result in all columns and rows being imported).
Enter two row numbers to specify the row range for partial import. The default From and To settings are 1 and 0 respectively (which will result in all columns and rows being imported).
Skip columns must be an integer value greater than or equal to 0. If Skip Columns = 0, no columns are skipped on import.
This text box is only editable when Skip Columns is not zero. It must be an integer value greater than or equal to 1.
If Skip Columns > 0, then the Import Wizard repeats importing Read Columns column(s) and skipping Skip Columns column(s) until the end of the file or Partial Import range settings are satisfied.
Skip rows must be an integer value greater than or equal to 0. If Skip Rows = 0, no rows are skipped on import.
This text box is only editable when Skip Rows is not zero. It must be an integer value greater than or equal to 1.
If Skip Rows > 0, then the Import Wizard repeats importing Read Rows row(s) and skipping Skip Rows row(s) until the end of the file or Partial Import range settings are satisfied.
Click this button to apply the range settings.
This is only available for ASCII files. If non-numeric data is interspersed with numeric data, you can use this control to decide what action should be taken when non-numeric data are encountered (typically, such non-numeric data is used to identify and separate various datasets in a file).
This drop-down has four options:
Import will be terminated when the first non-numeric data item is found within the data.
Non-numeric data will be skipped (see Read as Text).
Non-numeric data will be read in as text. If the column Format is set to Text & Numeric, the text will be visible in the resulting worksheet page. If the column Format is set to Numeric, the text will display as missing values.
A new hidden workbook is started if non-numeric data are encountered.
A new worksheet is started if non-numeric data are encountered.
A new column is started in the same worksheet if non-numeric data are encountered.
This window displays the imported data as it will look in the resulting worksheet. Note that you can right-click the title of each column and set its format and destination with the short-cut menu.