can we have cell value

[#1]

HI can we get any cell value from a straight table to variable in qlikview ?

[suniljain]

set table = ActiveDocument.GetSheetObject( "CH01" )
for RowIter = 0 to table.GetRowCount-1
for ColIter =0 to table.GetColumnCount-1
set cell = table.GetCell(RowIter,ColIter)
msgbox(cell.Text)
next
next

[brindlogcool]

  Thanks Sunil,

  The code is very useful . I want to get the maximum value of a specific column.If there are 10 rows in a straight or pivot table, then i would like to get the max value of 10 rows. Is it feasible.

[murozel76]

Hello,

I have a very similar problem, but I can not make the code above work as it is i.e. "set cell = table.GetCell(Rowiter, Coliter)" can only work when written as "set cell = table.GetCell(Rowiter, Coliter).text". However, this time the variable takes it as "text" and can not be used for any mathematical operation. Any help on this appreciated, please.

Regards,