Which MS Excel formulas are possible to use in the DataTable? I am search

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Testing >> Automation Testing >> QTP

WinRunner Interview Questions

Load Runner Interview Questions

QTP Interview Questions

Test Director Interview Questions

Rational TestSuite Interview Questions

Silk Test Interview Questions

Automation Testing AllOther Interview Questions

Question

Which MS Excel formulas are possible to use in the 
DataTable? I am searching a formula for searching a field 
in the datatable

Question Submitted By :: Guest

I also faced this Question!!

Rank

Answer Posted By

Re: Which MS Excel formulas are possible to use in the DataTable? I am searching a formula for searching a field in the datatable

Answer
# 1

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

0 No

Vikram

Re: Which MS Excel formulas are possible to use in the DataTable? I am searching a formula for searching a field in the datatable

Answer
# 2

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

0 No

Sandeep

Question	Asked @	Answers
Other QTP Interview Questions


how to write regular expression for Date field?	Google	7
How can we do this one ? at runtime qtpwindow and browser aren't disply on monitor (or) aren't visible on desktop?how?		1
Hi any body can tell me the in detaled information about Description.Create() thanks in advance		2
Hi. plz expalin abouit SetToProperty, SetRoProperty, GetToProperty, GetRoProperty,GetToPrperties. with examples.		3
Explain in brief about the QTP Automation Object Model.		1
What is the difference between functions and actions in QTP?	Verizon	3
How to handle recovery scenario for a application crash.write script for this.	Polaris	2
How to test background color and dynamic images which are moving during runtime?	CTS	6
How can i Save the snapshots in a specified folders using Scripting in QTP?		1
what is the use of descriptive programming in QTP ? when we need to use DP? can we test the application completely with out useing DP?? please explan with example		1
How the exception handling can be done using QTP		5
When i use paramateriztion for tickets in flight reservation application , the tes'll run for first iteration but for the second iteration it'll give this details, but the second iteration is failed. Pls anyone clarify it. Cannot find the "Agent Name:" object's parent "Login" (class Dialog). Verify that parent properties match an object currently displayed in your application.		1
How will you handle the situation when object is not captured during record?		2
Hi All, I want to know how can we schedule QTP scripts. Am using 9.5 version and in our office they want to schedule individual scripts of QTP so that it can run unattended during night time, Please help me how to do that. 2. what is the use of silent test run in qtp can I schedule the scripts in Silent runner, Please explain. 3.I retrieved data from the database using output value -> Database output value. the result of the query for eg is 5 rows, iam able to output the first row by selecting the cols and adding it to output, but am not able to do it for the rest of the rows. please tell me how to do it. Sorry for posting so many qns, am not able to find answ to any of the above in any websites, hoping that someone would really help me with these here, please help me. awaiting for ur immediate revert. Priya		4
It is very difficult to test in manual for that we go to DATA DRIVEN TEST.		3
I want to run my qtp scipt on the system where qtp is not installed .I don't want to install qtp but i want that system should use the qtp from another system in lan just the qtp instance should be launched on that system without having qtp installed on it .I probably know the solution that it will be solved through RMI but how to get this problem solved plz help i anyone know the answer	Cimcon	3
What are the Features & Benefits of Quick Test Pro (QTP)..?		4
Please have a look at this: a = Browser("Travel Boutique Online").Page("Travel Boutique Online_2").webelement("innerhtml:=2622").getroproperty("y") a=a+9 msgbox a Browser("Travel Boutique Online").Page("Travel Boutique Online_2").image("alt:=check","y:=a").click Now please let me explain. As clear from code I am trying to enter value of variable 'a' as Property y. But each time QTP AND MY SYSTEM stops responding when this line is execcuted. But When i enter some number in place of 'a' in the last line. it works fine. Please let me know what I am doing wrong at time of entering the variable in last line. Thanks a lot		3
When we parameterise some field ex. Textbox is there any way that we can generate a specefic number of random values (For alphabetical values if possible) instead of manually entering values in the data table		2
Hi Friends... By using QTP , can we test .net products...and that product supports different languages.. thanx in advance..		1

For more QTP Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com