---
url: >-
  /statelake/administering-statelake/designer/data-definitions/file-definitions/excel-file-definitions/design-excel-file-definitions/workbook-dataview-records-tab-excel-file-definitions.md
---

# 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.

::: info
**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. |