Excel Read Wizard Operation Guide

Excel Read Wizard

Excel Read Wizard is a function to specify the range for Read From Sheet by simply dragging on Microsoft Office Excel(hereafter: Excel application).

Excel Read Wizard Setting Screen Properties

Item name Description Remarks
Sheet name The name of the selected sheet.
The sheet shown in Excel application changes when the sheet name on the setting screen of "Excel Read Wizard" is modified.		  
Reading starting cell Select Read Range is displayed in the selected cell address to start reading.
  • Cannot enter directly.
Column list Column name/format selected in "Select range of reading" is shown.
Selected column name is shown after "Get column name".
  • For more information on each item, refer to Read From Sheet.
Get column name "Get column name" dialog appears.
  • During the initial display, it is invalid.
  • It is shown after reading range is selected.
Reading end condition The row under the range selected in "Select range of reading" is set as the end reading condition.
  • For more information on each item, refer to Read From Sheet.
Add "Add end reading condition" dialog appears.
  • During the initial display, it is invalid.
  • It is shown after reading range is selected.
Delete Delete the selected end reading condition.
  • During the initial display, it is invalid.
  • It is shown after reading range is selected.
  • Invalid when all the end reading conditions have been deleted.
Select "Select range of reading" dialog box appears.  
Cancel "Excel Read Wizard" dialog closes.
  • Excel application will not be closed by pressing [Cancel] button.
Finish Closes "Excel Read Wizard" setting screen and Excel application, and reflect to the settings in the wizard to the properties of Read From Sheet.
  • During the initial display, it is invalid.
  • It is shown after reading range is selected.

Excel Read Wizard Operation

Start Excel Read Wizard

  1. Press [Start Excel Wizard] from the properties of Read From Sheet.

  2. Designer shows "Start Excel Wizard" dialog box.

  3. Excel file selected in [File] is shown read-only, and "Excel Read Wizard" setting screen starts.

Select Read Range

  1. Press [Select] button.

  2. "Excel Read Wizard" setting screen closes, "Select range of reading" dialog is shown.

  3. Drag on the cells to select a range to read, and press the [OK] button.


  4. "Select range of reading" dialog closes, "Excel Read Wizard" setting screen is shown.
    To reflect the selected reading range, the following settings are made.

    Item name Setting value
    Reading starting cell The starting cell of the selected reading range
    Column list / Column name The value of the first row in the selected reading range
    Column list / Style The format of the cells in the first row of the selected reading range
    Reading end condition / Column name The column name of the first row in the selected reading range
    Reading end condition / Row number The number of row under the selected reading range
    Reading end condition / Condition value [(Not specified)]
    Reading end condition / And/Or [AND]


  5. Press [Finish] button, and the settings will be reflected in the properties of Read From Sheet.

Get column name

To change the column names in bulk, do as the following.
  1. Press the [Get column name] button.

  2. "Excel Read Wizard" setting screen is closed, "Get column name" dialog appears.

  3. Drag to select the row to use as column name on the cells and press [OK] button.
    Column name can be specified by one row of cells that has the same column number with the selected range in [Select range of reading] dialog.


  4. "Get column name" dialog box closes and "Excel Read Wizard" setting screen appears.
    Column name selected in [Column name] of [Column list] is set.


  5. Press [Finish] button, and the settings will be reflected in the properties of Read From Sheet.

Edit reading column

To modify column name and format individually in the "Excel Read Wizard" setting screen, do as the following.
  1. Focus to the item to edit in [Column list] and double click.

  2. "Edit reading column" dialog appears.


  3. Press [OK] button to close the screen and reflect the editing result to [Column list] in the "Excel Read Wizard" settings screen.

Add reading end condition

To add the end reading condition on the "Excel Read Wizard" setting screen, do as the following.
  1. Click [Add] button .

  2. "Add end reading condition" dialog appears.


  3. Press [OK] button to close the screen and the end reading condition is added to the [Reading end condition] in the "Excel Read Wizard" settings screen.

Edit reading end condition

To modify the Reading end condition set in "Excel Read Wizard" setting screen, do as the following.
  1. Focus to the item to edit in [Reading end condition] and double click.

  2. "E end reading condition" dialog appears.


  3. Press [OK] button to close the screen and reflect the editing result to [Reading end condition] in the "Excel Read Wizard" settings screen.

Delete reading end condition

To delete the Reading end condition set in "Excel Read Wizard" setting screen, do as the following.
  1. Focus on the item to delete in [Reading end condition] and press [Delete] button.

  2. The condition selected in [Reading end condition] of "Excel Read Wizard" setting screen is deleted.
    Confirmation will NOT be made after pressing [Delete] button.

End Excel Read Wizard

To complete the wizard settings

  1. Press [Finish] button.

  2. Excel Read Wizard and "Start Excel Wizard" dialog in Designer is closed, and the settings of the wizard will be reflected to Read From Sheet.

To cancel the wizard settings

  1. Press [Cancel] button to close the Excel Read Wizard.

  2. Close the Excel application to close "Start Excel Wizard" dialog.
When pressing the [x] button "Start Excel Wizard" dialog of Designer, "End Excel Wizard" dialog box appears.
Press [OK] button or [x] button in "End Excel Wizard" dialog box and the dialog and Excel Wizard are closed.

Specification Limits

Notes