The datasheet definition object ties together the view definition, template, document, and class definition of the object to be created in the published domain.
Create a datasheet definition object just like you would for the Excel Load but add additional information to control the publish process.
Datasheet definition details:
-
Enter the datasheet type (for example, EquipmentList). This is a free entry field to assist in classifying the different datasheet definitions.
-
Select the view definition modeled earlier.
-
Select the Template document just checked in.
-
Select the target class definition for the objects to be created.
Excel publish settings:
-
Enter the document title (will be set on all published documents using this template).
-
Enter the published document category (for example, Process Documents).
-
Enter the published document type (for example, Process Published Documents).
-
Enter the published document sub-type if needed.
-
Enter the class definition of the published document mentioned above.
-
Enter the details of the relationships to be created between the published objects and the published document.
-
The format is ObjectInterface,RelDef_21/12.
-
The object interface is a unique interface on the published objects.
-
The relationship definition is that between the published objects and the published document in the direction from the document to the object. Usually this will be NonDrawingItemCollection_21.
-
Now that the data list definition links the view definition to the template document, you can map the view definition properties to the cells in the Excel template.