Working with Excel: Sheets

Spreadsheets from Excel 2007 and later are supported. Excel file types of xlsx and xlsm only are supported.

This spreadsheet must have one Device tab and at least one of each Data and Template tabs. Other tabs are ignored by Gen.IT.

•Device-<Description>

•Data-<Description>

•Template-<Description>

•Globals-<Description>

Enterprise users may use sheets within up to 10 spreadsheets. The sheets will be aggragted into single data tables within Gen.IT (v2.9+).

<Description> are optional user configurable labels that have no significance to the Gen.IT application.

Device tabs are used to define devices and associated templates.

The two sets of tabs are dependent on each other and are linked via the ID values on each tab. All Device and Data tabs must contain the same amount and equal ID values, and no duplicate ID’s must exist on a single tab. Typically, the row or column number is used as the ID, with the ID cell formatted as ‘ID:[0-9]’.

Device and Data tabs can be defined in one of two ways – ID per Row, or ID per Column – and must be defined the same way within any given spreadsheet.

Device Definition must be added to spreadsheets named ‘Device-<Description>’.

Variables must be added to spreadsheets named ‘Data-<Description>’.

Templates must be added to spreadsheets named ‘Template-<Description>‘.

Global Variables must be added to spreadsheets named ‘Globals-<Description>’.

All other spreadsheets will be ignored.

Excel files may be selected in the Settings -> Edit Project Settings menu.

A special ‘ID‘ column/row is required on all Device and Data sheets. This column/row tells Gen IT how to link together the data fields spread across multiple sheets. The ‘ID’ column/row must be identical between sheets, and must not contain any duplicate values. The ID column/row entries are formatted as ‘ID:XX’

As of version 2.6, Device and Data sheets can use a column or row format. The format may be selected in the Settings -> Edit Project Settings menu (up to v2.8), or will be auto-detected from v2.9.

The function and content remains the same between the 2 options, but the content is rotated by 90 degrees.

See the included sample spreadsheets for examples.