Worksheets in .xlsm File
For every class definition of an object that is exported, an Excel worksheet will be created and named the same as the class definition’s UID. Because UID and Name are the same for class definitions, the worksheet’s name is also the class definition’s Name.
For relationship objects (class definition UID = Rel), a separate Excel worksheet will be created containing every relationship type (DefUID). The worksheet will be named based on the UID for the relationship definition for that relationship.
If a view is exported, the first worksheet in the Excel workbook will contain the view and will be named based on the exported view.
Rows in Excel Worksheet
The first cell on the first row contains the class definition for the objects displayed on that worksheet. For all worksheets except those containing relationships, the text in this cell matches the name for the Excel worksheet. This cell will contain a comment that includes the following:
-
Rows=# of exported rows (all worksheets except first worksheet for exported view)
-
View=name of exported view (only first worksheet of exported view)
-
UID1=comma-delimited set of class definitions (worksheet names) that contain legitimate objects for UID1 (only for relationship worksheets)
-
UID2=comma-delimited set of class definitions (worksheet names) that contain legitimate objects for UID2 (only for relationship worksheets)
The rest of the first row of each Excel worksheet contains the names of each of the properties for the objects displayed on that worksheet.
For every object that is exported, a row in an Excel worksheet will be added. This row will contain all the property information for that exported object.
The number of objects initially displayed on a particular worksheet should match the number of rows in the Rows= comment in the upper left cell for that worksheet.
Cell Information
Each cell (other than those on the first row) should contain the value for the particular property (from the first row) for the exported object for that row.
For relationship worksheets, the cells for the UID1 and UID2 columns contain a comment that identifies the name for the object corresponding to the UID in that cell.
SchemaRevVer property values are exported along with all the other property information. However, since these values for existing objects should never be changed by the user and these values are automatically assigned to new objects, the column for this property is hidden.
The cells in the first worksheet for an exported view contain the values for that view. Cells that are shown as underlined blue text are hyperlinked to the corresponding objects in the workbook. Clicking a hyperlinked cell takes you to the corresponding object in the workbook. Cells on this workbook that contain arrows, when clicked, take you to the corresponding relationship in the workbook.
