Rockwell Automation 9307 FactoryTalk EnergyMetrix - Manual (Page 272)

FactoryTalk EnergyMetrix Software
272
Methods
Worksheet Object
The Worksheet object presents a worksheet within the workbook that the MPR Excel
script is working with.
Instancing
The Worksheet object is 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
Methods
Method Description
Add(WorksheetName As
String) Create a Worksheet within the workbook and returns a
worksheet object
Delete(WorksheetName
As String) Delete a Worksheet within the workbook
Property R/W Description
Name as String R Worksheet name for the worksheet
Range(range
identifier) as Excel
range R Range object to get access to any range in the
worksheet
Cell(cell
identifier) as Excel
cell R Cell object to get access to any cell in the worksheet
Rows as Rows R Collection of rows in the worksheets
Columns as Columns R Collection of columns in the worksheet
Method Description
Worksheet
(WorksheetName as
String) Create an Worksheet object representing a worksheet in the
workbook.
RangeUsed() as Range The Range identifying the cells used in the worksheet.