Workbook Dataview - Records Tab - Excel File Definitions

Workbook Dataviews along with the Record and Field Definitions they contain, offer additional settings to configure them with respect to the Excel Workbook and Worksheet contents they work with.

The Excel Woorkbook Dataview will prompt for information about the file as specified on the initial screen, starting with the Records tab.

Statelake forces all record names and field names to uppercase for consistency across all definitions.

Fields

Field Name	Description
Name	The Name of the dataview.
Record Position	Used for output or destination Excel files only. It is the sequence that the dataview output at the same level will have - particularly where there are siblings. Where there is more than one ( 1 ) dataview, the dataviews must hold a different and unique Record Position within the definition. For instance there could be three ( 3 ) dataviews - A, B, and C. So rather than have them in the natural order of A-B-C, you could have them as B-C-A by specifiying the record position 3 for A, 1 for B, and 2 for C.
Worksheet	The Worksheet identifier. This setting identifies the worksheet from which cell values will be read/written by fields in the dataview by default. Worksheets are identified either by name or numeric ID. Individual field definitions may override this by specifying a worksheet in their field cell address setting. If no worksheet is identified by a dataview then the default worksheet specified on the File Definition is assumed.
Cell Range	This setting identifies the Cell Range in the worksheet which defines the extent of the “recordset” (i.e. the number of rows) in the worksheet. The range is expressed in the standard Excel format, e.g. B4:H24 If defining a dataview to read/write a single record then a single cell may be specified, e.g. C6 The columns specified in the range (or cell) are not as important as the rows, since the field definitions in the dataview will identify specific columns - which need not necessarily even be in the range specified here. When reading/writing records, the dataview maintains a record “pointer” which advances through the specified rows in the dataview range for each record. When reading from a worksheet, rows are read until the first defined worksheet field in the dataview is null, or the worksheet cell range row limit is reached. However, during Preview this cell range can be critical between having data displayed or not.
Empty Rows to Trigger EOF	The number of empty rows to encounter before assuming end-of-file status. The default value is one (1).

Buttons

Button Name	Description
OK	Click to save any changes you have made. All changes will be lost if you do not click the OK button.
Cancel	Click to Cancel any changes you have made.