+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to get more than one Local DataTable sheet for one Action? (/Thread-How-to-get-more-than-one-Local-DataTable-sheet-for-one-Action)
How to get more than one Local DataTable sheet for one Action? - Uma - 09-30-2011
Hi,
I have a 6 Pages in Excel and I have 3 Actions,so QTP gives 3 sheets in the local data table.
1 Page details are used by Action1.
2 Page details are used by Action2.
The another 4 Excel Pages are used by Action3.It has more than 25-30columns.
So I want to use 4 different Pages in the local dataTable.[Again I dont want to divide this as a 4 Actions,because all these data needs to work together.]
Is it possible?or QTP will provide only one Page for one Action?
Any help?
Thank you,
Uma
Solved by using following,
DataTable.AddSheet("xyz")
RE: How to get more than one Local DataTable sheet for one Action? - rajpes - 10-01-2011
As i gave a hint to your previous problem, you can dump any sheet from excel at any point of run time
Datatable.importsheet filename,4,action3
work with it
Datatable.importsheet filename,5,action3
work with it
***************
or better you create workbook objects through excel com (createobject("excel.application"))
RE: How to get more than one Local DataTable sheet for one Action? - Uma - 10-05-2011
Thank you,
It am dumping the sheet from excel..
Uma