Rockwell Automation 9307 FactoryTalk EnergyMetrix - Manual (Page 276)

FactoryTalk EnergyMetrix Software
276
Row Object
The Row object presents a row within a worksheet of the workbook that the MPR Excel
script is working with.
Instancing
The Row object is not a creatable object.
Accessing
The Workbook object automatically creates Row objects for each worksheet in the
workbook (accessible using the Excel.Workbook.Worksheets.Rows property) and MPR
Excel script code can access any row in a worksheet using the Row objects.
Methods
Columns Collection
The Columns object is a collection of Excel Column objects.
Instancing
The Columns object is not a creatable object.
Accessing
The Workbook object automatically creates one Columns object for each worksheet in the
workbook.
Properties
Method Description
InsertRowsAbove(NumberOfRows
As Integer) Insert a number of rows above the rows in the
range
InsertRowsBelow(NumberOfRows
As Integer) Insert a number of rows below the rows in the
range
Delete() Deletes the row
Property R/W Description
Column(index)
As Column R Collection of Column objects that represent the columns in the
worksheet.