Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
data transfer across sheets of datatable
#1
Solved: 10 Years, 7 Months, 3 Weeks ago
hi,
i have 10 rows of data in global sheet of datatable.
i want to transfer all the data to the local sheet.
how can i do it ?


cheers,
AJ
Reply
#2
Solved: 10 Years, 7 Months, 3 Weeks ago
Code:
Dim rCount

rCount = datatable.GetSheet("Global").GetRowCount

For i = 1 to rCount

DataTable.SetCurrentRow(i)
DataTable.Value("ColumnA", "Action1") = DataTable.Value("ColumnA", "Global")
DataTable.Value("ColumnB", "Action1") = DataTable.Value("ColumnA", "Global")
DataTable.Value("ColumnC", "Action1") = DataTable.Value("ColumnA", "Global")

Next


That should work!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Does QTP support writing runtime data to multiple sheets in excel Shwethareddy 2 3,529 10-16-2012, 12:20 PM
Last Post: Shwethareddy
  comparing two excel sheets in QTP kodhanrajesh 0 4,195 08-31-2011, 09:01 AM
Last Post: kodhanrajesh
  Weblist to weblist fields transfer not working Milindt43 0 1,827 06-08-2011, 03:23 PM
Last Post: Milindt43
  how to get rowCount for Devexpress xtraGrid detail sheets? hotzone 0 5,161 12-31-2010, 05:01 AM
Last Post: hotzone
  how to store data in datatable from other application? vimal singh 2 3,820 07-16-2010, 11:24 AM
Last Post: vimal singh

Forum Jump:


Users browsing this thread: 1 Guest(s)