See also: Composition of an Excel File

When working with component, it's recommended to use the Components Sheet. 


To import/export components, use one of the following config files:

  • defaultConfig: The ~DefaultSheet will contain all the basic columns.

  • defaultModelConfg: The ~DefaultSheet will contain basic columns as well as the isIn column for outgoing isIn relations. 
  • defaultActive: The ~DefaultSheet will contain all the basic columns and those which work with the Active-Framework.
  • defaultImport: Similar to the defaultConfig but already contains a Default Data Sheet that you can fill and import.


This file contains the following by default in the ~Structure sheet:

Sheet namePredicateInternal Id SFormatSheet Type
Defaultn:network or n:device or n:childPoint<-n:device
Components


  • Sheet name: the name of the data sheet.

  • Predicate: A NEQL query which will determines which components will be imported/exported in the associated Data Sheet.

  • Internal Id SFormat: Optional value. This value allows the customization of the Internal Id of the rows in the associated Data Sheet during the export. If the cell is empty, the displayName of the component will be used as a base for the id.
  • Sheet Type: optional value. Can be given the value "Component" in order to work on any Component and to have access to most of the btibExcel features.


Here are all the available feature for the Component Sheet