Rockwell Automation 9307 FactoryTalk EnergyMetrix - Manual (Page 270)

FactoryTalk EnergyMetrix Software
270
Accessing
MPR Excel script code accesses the workbook that is automatically opened with the script
runs.
Properties
Methods
Worksheet 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
Object and Collection Definitions
Workbook Object
The Workbook object is use as the main reference to the workbook that the script works
with.
Instancing
The Workbook object is not a creatable object. For the MPR Excel reporting function, the
system expects an excel workbook with the same name as the script to be located on the
FactoryTalk EnergyMetrix server on the ExcelTemplates share/folder.
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.
CustomProperties As
CustomProperties 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