next »

[Srikanth Reddy]

How to create a data table and use it in the script?How to link it to the current test?

[praveen kumar]

this does not answer ur question directly, but should help u considerably:
option explicit

Dim global
Dim strmaster, strprime
Dim m,p,i
Dim pth
strmaster = empty
strprime = empty

pth = "c:\AgentCodes.xls"
datatable.ImportSheet "c:\ExceptionStates.xls","Apple States",global
datatable.AddSheet ("master agent")
datatable.AddSheet("prime agent")


datatable.ImportSheet pth,"master agent","master agent"   'look help to understand more
datatable.ImportSheet pth,"prime agent","prime agent"
m = datatable.GetSheet("master agent").setcurrentrow(1)
p = datatable.GetSheet("prime agent").setcurrentrow(1)

datatable.SetCurrentRow (1)
'msgbox "  master: " & m & "  prime: "& p
For m = 1 to datatable.GetSheet("master agent").getrowcount
   strmaster = strmaster & datatable.value("master","master agent") & vbcrlf
   datatable.getsheet("master agent").setnextrow
Next
For p = 1 to datatable.GetSheet("prime agent").getrowcount
   strprime = strprime & datatable.Value("prime","prime agent") & vbcrlf
   datatable.GetSheet("prime agent").setnextrow
Next

msgbox "contents of master agent xl sheet "& vbcrlf & strmaster &vbcrlf &" total rows: "& datatable.GetSheet("master agent").getrowcount
msgbox "contents of prime agent xl sheet " &vbcrlf & strprime & vbcrlf & " total rows: " & datatable.GetSheet("prime agent").getrowcount

PS: if u want to increment the row count of global sheet, use datatable.getsheet("global").setnextrow

[Meir Bar-Tal]

I wish to add:

1) The Global sheet is the default sheet of the DataTable Object, so it isn't needed to use GetSheet for the Global sheet.

2) It is accustomed to use the constants dtGlobalSheet and dtLocalSheet to refer to the Global sheet and the sheet attached to the current action.

I hope this is useful.

Good Luck!

[praveen kumar]

hi meir,
this is what i have observed:
when i am working with multiple data sheets, the one on which the most recent operation is done, becomes the current one.
taking my below example, if say datatable.getsheet("master agent").getcurrentrow, retrieve a couple of values & then say datatable.setnextrow, next row for "master agent" data table gets set, but NOT for global data sheet. hence, i specifically used, datatable.getsheet("global").setnextrow. this is guranteed to work..
also, i seldom got dtGlobalSheet & dtLocalSheet work to my needs... hence, i don't use them much...
please let me know if you have a different point of view.

[Meir Bar-Tal]

Fine. I wanted to add, not argue with you.

[Srikanth Reddy]

thanks a lot praveen and Meir.this helped me a lot.