Interested to Buy Any Domain ? << Click Here >> for more details...
Which MS Excel formulas are possible to use in the
DataTable? I am searching a formula for searching a field
in the datatable
- 3 Answers
- 9217 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep
Please refer to the folder with your SCRIPT name stored on
your DRIVER.
QTP create folder with Test name at a location where you
saved Script.
Now in same folder one file exist Default.xls.
This Excel file will contain all your datasheets for all
actions.
Open same file in MS - EXcel. And enter any formula you
want to enter.
I hope this solves problem,
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vikram
ur question was not clear 2 me ,
but 2 open excell sheet which is already created
we use
set obj=createobject("excell.application")
obj.workbooks.open"path of excel sheet"
to get data from excell sheet,we use
v=obj.sheets(1).cells(i,j)
msgbox v
i means rows
j means columns
to insert data in to particular cell, we use
obj.sheets(1).cells(i,j)="vikram"
to count no.of.rows.we used
v=obj.sheets(1).usedrange.rows.count
msgbox v
to count no.of.coloums.we used
v=obj.sheets(1).usedrange.columns.count
msgbox v
| Is This Answer Correct ? | 1 Yes | 3 No |
How do u retrieve data from a text file into different variables. i.e. in a text file named "source" , the data is like : india,1000,japan,200,china,50,singapore,45050 this is given in the first line of the text file. in the second line of the text file the dta is: sun,moon,planet,river,earth,water if u use "readline" method by using FSO concept u can retrieve the entire line in to a variable. but i want to import each field (ex: "india" in one variable, "1000" in another variable etc..). Apprecitae proper replies.
What is Active Screen in QTP?
How QA specialist can identify when programmatic descriptions are useful?
How we can import data from database?
How to load a object repository(using VBScript) ... very urgent....
Differences between quicktest professional (qtp) and winrunner?
What is the extension of script and object repositary files?
Explain different recording modes?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
I need Major Help with a Script I recorded in QTP 9.5. I am recording scripts for a Web-based application(s) I have all the URLs for each application in Excel spreadhsheet so that QTP can pull that particular application from the spreadsheet and run it. The problem is QTP isn't recognizing one particular URL so when I hit run in QTP to run this script it opens the internet Explorer but isn't open the URL I have in the Excel spreadsheet. I've retyped the URL and still QTP won't open this Particular one for some reason. The site its self is working fine but for whatever reason QTP won't open it. How do I resolve this? I have a deadline of next Friday the 7th to complete this task so please help me in any way you can. Thanks in advance
Write a script to delete a specific row in a webtable.
Hi Guys, In one of my interviews, I was asked to Write a paragaraph explaining how much scripting I did in QTP? I don't know where to start and what to write. So I need your help in writing that.
WinRunner 
