Returns a cell or a group of cells.
&ExcelDocument.Cells(Row, Column, [ Height, Width ] )
Where:
Row
Is the row where the area will begin.
Column
Is the column where the area will begin.
Height
Is the height of the cells.
Width
Is the width of the cells.
Type Returned:
Numeric
Extended Data Types: ExcelDocument data type
Generators:
.NET,
Java, Ruby (up to GeneXus X Evolution 3), Visual FoxPro (up to GeneXus X Evolution 3)
It returns an ExcelCells object with cells forming the area which starts on a Row (row specified) and Column (column specified) and has a certain Height (cell height indicated) and Width (cells width indicated).
If the Height and Width parameters are not specified, only the cell located in the Row and Column will be returned.
Note: This method returns an error code, so it is possible to call it as a function (&Err = &ExcelDocument.Cells(…..)).
ExcelCells Data Type
ExcelDocument Data Type