GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Testing Tools  >  QTP
Go To First  |  Previous Question  |  Next Question 
 QTP  |  Question 592 of 684    Print  
QTP : Inserting a text into a cell of an excel sheet
What will be the script to insert a text or value into a cell of an excel sheet ? Pls help...Thanks in advance.


  
Total Answers and Comments: 1 Last Update: November 30, 2007     Asked by: cyber_coolie 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 30, 2007 13:16:06   #1  
prashanth.n Member Since: November 2007   Contribution: 18    

RE: QTP : Inserting a text into a cell of an excel sheet
The following code will be useful for inserting text into excel.

Dim app
Dim book
Dim sheet
Set app CreateObject("Excel.Application")
Set book app.workbooks.open("e:temp.xls")
Set sheet book.activesheet
sheet.cells(1 1) "hello"
book.save
app.quit

 
Is this answer useful? Yes | No

 Related Questions

Answer posted by shreethik on 2005-06-09 08:36:38: Output values enable to view the values that the application talkes during run time.When paramaterised, the values change for each iteration.Thus by creating 
Latest Answer : By using Text Output value we can capture a runtime value form the application under test and store it in a variable or in a localsheet ...

Latest Answer : font color change?font size?how can we save data in excel file?how can we open excel file at run time?how can we fetch data from excel file? ...

Latest Answer : Global action sheet belongs to current test script. Local action sheet comes into picture when using multiple action and if you want to run a copy of an existing action differently than other actions in the same script and those other actions are reusable ...
Read Answers (4) | Asked by : Mann

Latest Answer : Retrieve text from TextBox:var_Text = Browser().Page().WebEdit().GetROProperty("value")Retrieve text from ListBoxvar_Text = Browser().Page().WebList().GetROProperty("value")Retrieve text from Webtable/Datagridvar_Text = Browser().Page().WebTable().GetCellData(rownumber,coulmnnumber) ...
Read Answers (4) | Asked by : mann

View Question | Asked by : vknowth

What is the best way to run the applications in QTP. "Not preferred Record/Playback".Normally people will run from the 'excel'.can you please give me the best idea for this.
Read Answers (4) | Asked by : RAM

Latest Answer : Hi,To close the application windows, you can use the following command:SystemUtil.CloseDescendentProcessesThe above command closes all the open IE windows. ...
Read Answers (3) | Asked by : steven

I need some coding help:I have a section of my application that looks up legal case numbers. So for example, I type 04TR000001 as my case number click GO and it will open the appropriate case.I have a data sheet with a parameter CASENUM and it has about 50 case numbers I now need to be able to verify the right case has opened. There is a bunch of case header information that comes up when a case is opened. It includes for example: --------------------------------------------------------------------LAKE

Recently I was asked this question in one interview .Can someone throw some light please..You are buying items from some online retail selling store.Letus say you are buying items from amazon.com. You bought cell phone and put in the cart then you find some shipping cost associated with it.You bought another item and put in the cart and notice that it is free shipping.You decided to check out and at the time of checkout you see the shipping costs got reversed for the two items.You are already running
Read Answers (4) | Asked by : babuda

Latest Answer : Check point declaration is basically compare two values and give the result..Suppose For Standard checkpoint I have given Text for username should be Leena,so if any other text appers in that feild ,suppose mona appered in that feild then checkpoint fails ...


 Sponsored Links

 
Related Articles

SQA Software and Tools

SQA Software and Tools In quality assurance it is always important to get all the help we could get In other industries developers could easily check the products manually and discard those that do not meet the standard The length and the width of the product are checked to maintain standardization
 

Business Network Virtual Communication Tools

Business Network Virtual Communication Tools Since ages the Business community heavily relied on face to face communication for building Business relationships Face to face communications formed the basis for trust in a relationship An individual’ s appearance or the physical appearance of
 

Using XML with Microsoft Excel

Using XML with Microsoft Excel One of the most useful features for a programmer would be Microsoft Excel s capability to support XML schemas which are user defined Though it is not a very prominent feature which can be obviously noted it still exists and is very functional tool In simple English it
 

What are Data Access Tools

Data access is the process of entering a database to store or retrieve data. Data Access Tools are end user oriented tools that allow users to build structured query language (SQL) queries by pointing and clicking on the list of table and fields in the data warehouse. Thorough computing history, t
 

Testing and Integration

Once the software is complete, it will go though rigorous testing before its actual integration.  In this article we will take a look at different types of software testing and also different types of integration. With the diversity of business setting and software development models, it al
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

SAP and Microsoft tools for Customer Service

World’s largest car dealer to use SAP and Microsoft tools for Customer Service Inchcape, the London-based largest car dealer in the world, is making itself much strong now by improving its customer services arising from major SAP and Microsoft implementations. The company has also vowed to
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Career Assessment Tools

For those not sure what type of career they are interested in pursuing, career assessment tools can provide help. There are assessments available at career centers that are designed to help people figure out a good career option. They explore your personality, skills, interests, and values, and can
 

Advantages of Using SAP R/3 in comparison with other Similar Tools

ERP system takes a lead role because of some of the following reasons: Many large corporations use several different and separate information systems, often because they have merged with and/or acquired other companies with varied systems. An ERP system integrates these separate information systems
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape