Can anybody give the script of below things. 1. Add sheet 2. Adding colum

Advertise your Business Here

Refer this Site

Login | Sign Up


	Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 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

Can anybody give the script of below things.
1. Add sheet
2. Adding columns
3. Set the values in that columns(In the rows)
4. Close the sheet
5. How can we create 3 sheets in one Excel sheet??

Question Submitted By :: Priyareddy

I also faced this Question!!

Rank

Answer Posted By

Re: Can anybody give the script of below things. 1. Add sheet 2. Adding columns 3. Set the values in that columns(In the rows) 4. Close the sheet 5. How can we create 3 sheets in one Excel sheet??

Answer
# 1

hi 
data table methods:
1.Add sheet: adds specified sheet to runtime data table
syntax: datatable.addsheet("sheet name")

3.set currnt row method;
sets the specified row as the current row

syntax: datatable.setcurrentrow(rownumber)

Is This Answer Correct ?

0 Yes

0 No

Saritha

Answer
# 2

1.Datatable.AddSheet("Global")
2.Datatable.GetSheet("Global").Addparameter("User_name")
3."srikanth"=set Datatble("User_name", dtGlobalSheet)
4.Datatable.close
5.Datatable.Addsheet("Sheet1","Sheet2","Sheet3")

Is This Answer Correct ?

0 Yes

0 No

Srikanth

Question	Asked @	Answers
Other QTP Interview Questions


There is a name "AJAY" how do u count no.of. "A" in that name ?		2
We need to verify the user name & password in for the user validation. But we don't want to use the parameterization/ loop for user name and password. What is the way in scripting so that user & password will generate automatically.	Tech-Mahindra	10
How to map Test cases to the script? Please do anwser urgently?Thanks		3
Can anybody give the code for ALL DATATABLE METHODS)(ex: datatable.getrowcount, datatable.getsheet etc....) and ALL DATABASE COMMANDS (like .getcelldata, which are used to retrieve data from a database and from a webtable)with examples.	Accenture	1
we have a link in a website or webtable How can we record link in that table or site? link is not static we don't know exact location of that link? how ? if u know pls give reply with script also?	Covansys	3
How many type of status messages are there ..explain?		4
what ar the challenges do we face while testing webbased applications using the automation tool qtp or any?	TCS	4
How many ways to configure the application in QTP,Explain	CTS	2
Check point what is how many types of checkpoint and explain	Accenture	2
How to call .vbs funtion , Library files in QTP? plz Explain indetail(chandana)	Wipro	4
What is the latest version in QTP?	Polaris	26
In QTP how to interact tool and application build?		1
Explain the difference between smart identification and object identification withn clear example. please it is very urgent	Wipro	1
After coming to know that QTP could not identify non-standard objects, we set those non-standard objects as virtual objects using Virtual object wizard. But how can we identify that qtp could not identify non-standard objects?		6
what is batch testing?		1
How to write script to display a message box having the "Date" value of the fourth mail(yahoo account). I've tried it with the web table concept but the content doesn't get displayed? Please help me out to resolve this :-)		2
How does QTP identifies the object in the application Mainly objectives are three type's OF PROPERTIES namely		3
What are Test case selection criteria for Automation?		2
Hi Friends, Can you please answer these questions of QTP Certification? 1.) What are bitmap checkpoints sensitive to? A. Image size and object type B. Object type and image type C. Screen resolution and object type D. Screen resolution and image size 2.)What are the phases in the QuickTest workflow? A. Plan, Record, Enhance, Run B. Prepare, Record, Verify, Run C. Plan, Create, Verify & Enhance D. Prepare, Create, Verify & Enhance, Integrate 3.) What are the two most commonly used ADO objects? A. Fields B. Execute C. Connection, RecordSet D. Open, ConnectionString 4.)What options are available to filter objects in the Target Object Repository pane when merging object repositories? A. Show all objects or Show only objects with conflicting object types B. Show all objects or Show only objects with conflicting descriptions C. Show only objects with conflicting logical names or Show only objects with conflicting object types D. Show only objects with conflicting logical names or Show only objects with conflicting descriptions 5.)Which of the following is an example of a missing resource? A. An object B. Run Results C. A Regular Action D. An External Action 6.)What method is used to retrieve the number of columns in the query results? A. Fields.Count B. Fields.Item(EOF) C. Fields.Count(BOF) D. Fields.Count.Value 7.)In VB Script functions, which one is false among the following a. Variables must be declared before use b. Variables may not be declared before use c. Variables may be declared without data types None		1
I am using Shared OR, and my collegues are also using Shared OR. How to merge Object Repositories?		6

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