KEYENCE CV-H5N User Manual
Page 106
4
CV-H5N-M-WW-NO4-E
4-22
4
Initial output cell (Sheet name: cell identifier)
Displays the coordinates of the first cell to receive output.
Reference
When specifying the [Initial output] cell, click the [Open Excel] button to open the Excel file.
After selecting the cell and sheet to receive the output, click the [Assign Cell] button to display the coordinates of that cell.
5
Output format setting: Column update
Turn this on to move down one cell when reading in data.
If the [Max column count] of the Excel sheet is reached, the next input will be read into the first cell of the next column and continue moving
downward.
The number of columns moved to the right is determined based on the output data.
The number of rows can be set from 0 to 66536.
Reference
If the number of rows is set to "0", the software will continue writing in the same cell.
6
Output format setting: Row update
Turn this on to move one cell to the right when reading in data.
If the [Max column count] of the Excel sheet is reached, the next input will be read into the first cell of the next row and continue moving to the right.
The number of rows moved down is determined based on the output data.
The number of columns can be set from 0 to 256.
Reference
If the number of columns is set to "0", the software will continue writing in the same cell.
3
When data collection starts, the Excel file specified in
Step 2 automatically opens and the output data from the
CV-5001 Series controller is written in the cells.