Interested to Buy Any Domain ? << Click Here >> for more details...
How do you copy a value from a cell in an msexcel sheet saved
on the desktop into QTP's datatable when the co-ordinates of
cell are given?
- 2 Answers
- 5712 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aruna
V CAN COPY THE CELL VALUES
GIVE THE CELL VALUE EX (1,1).COPY .............
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / pankaj
Call the excel first :
Set xl = createobject("excel.application")
Set wb = xl.Workbooks.Open("D:\test.xls")
Set ws=wb.Worksheets(sheet1)
datatable("Colname","Sheetname")=ws.cells(i,j) ' i and j
'would be known row and col into excel
Try this it will work for more doubt in QTP you can directly
post me question on my blog
http://quality2deliver.blogspot.com
| Is This Answer Correct ? | 2 Yes | 1 No |
Can we use Virtual Objects in Discriptive Programming?
Hi Friends, Would be great if you can provide the Model Question paper, Web site link or any reference s. Thanks & Regards, Byzoor,
how do we add a new sheet to data table in QTP?
i have data in excel sheet.i imported the data in data table.while doing parameterization,how the code knows it is a valid or invalid data?
What is the latest version of qtp?
What are Child Objects?
How to database testing by manualy?in my db having 100 records when i am retriving the data from db it shows in frent end 30 records how to find bug using QTP?plz Exp realtimers (Chandana)
i have written some lines of code today..tommorow some lines of code deleted in middle of that code..how to handle this type of script
What is the limitation to XML Checkpoints?
how to create user defined functions in QTP? can any one expalin me with example.. Thanks in Advance for help
How should I check my code( Before going to execute) without executing the script in QTP
How do I lauch my test website using code from qtp in different environmet, uat and PPTE?
WinRunner 
