Official Content

Returns a cell or a group of cells.   

Syntax

&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

Scope

Extended Data Types: ExcelDocument data type
Generators: .NET, Java, Ruby (up to GeneXus X Evolution 3), Visual FoxPro (up to GeneXus X Evolution 3)

Description

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(…..)).

See Also                 

ExcelCells Data Type
ExcelDocument Data Type

 






Last update: November 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant