Working with Excel: Sheets

Previous Next

Spreadsheets from Excel 2003 and later are supported. Excel file types of xls, xlsx and xlsm 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.



Template-<Description> ***


*** Customers with an enterprise license may use a separate Excel file for Template tabs.

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

All other spreadsheets will be ignored.

Enterprise customers may place templates in an Excel file of their own. This allows the templates to be places under change control, while the data Excel file may be dealt with separately. A template Excel file may be selected in the Settings -> Edit XLS 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 XLS Settings menu.

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.