Tuesday 10 April 2012

Getting all values from Global sheet or local sheets


Set dg=datatable.GlobalSheet
rc=datatable.GetRowCount
cc=datatable.GlobalSheet.getparametercount
For i=1 to cc
cname=dg.getparameter(i).name
set d=dg.getparameter(cname)
For j=1 to rc
val=d.valuebyrow(j)
MsgBox(val)
            next
Next

(OR)

sc=datatable.GetSheetCount
For i=1 to sc
rc=datatable.GetRowCount
cc=datatable.getsheet(sc).getparametercount
For j=1 to rc
   For k=1 to cc
f= datatable.getsheet(i).getparameter(k).name
Set h=datatable.getsheet(i).getparameter(f)
l=h.valuebyrow(j)
print l
Next
Next
Next

No comments:

Post a Comment