Rockwell Automation 9307 FactoryTalk EnergyMetrix - Manual (Page 271)

9 • ReportsPlus
271
Accessing
MPR Excel script code accesses the workbook that is automatically opened when the
script runs.
Properties
Methods
Worksheets Collection
The Worksheets object is a collection of Worksheet objects. The Worksheets and
Worksheet object provide access to the worksheets in the workbook, for populating data in
those sheets, for retrieving data and ranges of data from those worksheets etc.
Instancing
The Worksheets object is not a creatable object.
Accessing
The Workbook object automatically creates one Worksheet object for each worksheet in
the workbook (accessible using the Excel.Workbook.Worksheets property) and MPR
Excel script code can create additional worksheet objects if needed, as well as delete
existing ones if needed.
Properties
Property R/W Description
Properties As
DocProperties R/W Document properties collection that can be used to set specific
properties for any Office XML document, such as: Author, Title,
Subject, Category, Comments, Keywords, Status,
LastModifiedBy, Company, Manager etc.
CustgomProper
ties As
CustomPropert
ies R/W Custom Document properties collection used to add/edit custom
properties with the document/workbook.
Worksheets As
Worksheet
Collection R/W Collection of worksheets in the workbook
Method Description
Add(Worksheet As Worksheet,
Left As Double, Top As Double) Create a Worksheet object
Property R/W Description
Worksheet(index)
As Worksheet R Collection of Worksheet objects that represent the
worksheets in the workbook.