Refer to Excel Cell or Range Directly

[philipq]

Greetings,

2 Requirements please:
1) I need to directly refer to a particular excel cell by its reference like A1, B45 etc.
2) How do I obtain the row number of the activecell?
I know how to do this in VBA; kindly advise how to go about this in QM

Thanks,
Philip

[Gintaras]

Macro Macro2462

Code:

Copy      Help

ExcelSheet es.Init
;1) I need to directly refer to a particular excel cell by its reference like A1, B45 etc.
es.SelectCell("C5")
;2) How do I obtain the row number of the activecell?
int c r
es.GetRangeInfo("<sel>" c r)
out F"{c} {r}"

[philipq]

Thanks Gintaras,

So, once I obtian the c and r then can I refer to "R4" as shown below, where r=4

Macro Incentive Figures

Code:

Copy      Help

,es.Cell("R" r)

[philipq]

Or should it be:
Macro Incentive Figures

Code:

Copy      Help

,es.GetRangeInfo("<sel>" c r)
,str range.from("R",r)
,es.SelectCell(range)
,es.CellsToArray(name "sel")

[philipq]

Also if c is of type int then how do I get values of this cell by refering to it from and at a later point.

[philipq]

Is the below code correct:

Macro Incentive Figures

Code:

Copy      Help

,es.GetRangeInfo("<sel>" c r)
,range1.from(c,r)
,range2.from("R",r)
,es.SelectCell(range2)
,es.CellsToArray(name "sel")
,es.SelectCell(range1)
,es.CellsToArray(figure "sel")