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. |
|
Column list | Column name/format selected in "Select range of reading" is shown.
Selected column name is shown after "Get column name". |
|
Get column name | "Get column name" dialog appears. |
|
Reading end condition | The row under the range selected in "Select range of reading" is set as the end reading condition. |
|
Add | "Add end reading condition" dialog appears. |
|
Delete | Delete the selected end reading condition. |
|
Select | "Select range of reading" dialog box appears. | |
Cancel | "Excel Read Wizard" dialog closes. |
|
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. |
|
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] |