Rockwell Automation 9307 FactoryTalk EnergyMetrix - Manual (Page 275)

9 • ReportsPlus
275
Enums
Cell Object
The Cell object presents a cell within a worksheet of the workbook that the MPR Excel
script is working with.
Instancing
The Cell object is not a creatable object.
Accessing
The Workbook object automatically creates Cell objects for each worksheet in the
workbook (accessible using the Excel.Workbook.Worksheets.Ranges property) and MPR
Excel script code can access any cell in a worksheet using the Cell objects.
Methods
Rows Collection
The Rows object is a collection of Excel Row objects.
Instancing
The Rows object is not a creatable object.
Accessing
The Workbook object automatically creates one Rows object for each worksheet in the
workbook.
Properties
Constant Description
XLShiftDeletedCells.ShiftCellsLeft
XLShiftDeletedCells.ShiftCellsUp
Specifies how cells are shifted when a
specified range is deleted.
Method Description
InsertRowsAbove(NumberOfRows
As Integer Insert a number of rows above the rows of the cell
InsertRowsBelow(NumberOfRows
As Integer) Insert a number of rows below the rows of the cell
InsertColumnsBefore
(NumberOfColumns As Integer) Insert a number of columns before the columns of
the cell
InsertColumnsAfter
(NumberOfColumns As Integer) Insert a number of columns after the columns of the
cell
Property R/W Description
Row(index) As
Row R Collection of Row objects that represent the rows in the
worksheet.