Geeks Talk

Prepare for your Next Interview




Integrating Excel with QTP

This is a discussion on Integrating Excel with QTP within the QTP forums, part of the Software Testing category; Hi I have one question.How to integrate Excel sheet with Qtp? Example: I have written Test cases in Excel sheet,I want to integrate these test cases into QTP. ...


Go Back   Geeks Talk > Software Testing > QTP

Integrating Excel with QTP Integrating Excel with QTP

Register FAQ Members List Calendar Mark Forums Read

Reply

 

Thread Tools Display Modes
  #1 (permalink)  
Old 06-13-2008
Junior Member
  
Join Date: May 2008
Location: philadelphia
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
navitha is on a distinguished road
Integrating Excel with QTP
Hi


I have one question.How to integrate Excel sheet with Qtp?
Example: I have written Test cases in Excel sheet,I want to integrate these test cases into QTP.

Note:From QTP ,We can integrate with QC.but I want to integrate Excel sheet with QTP with out Using QC.(How we are using QC in QTP).


Please Let me know.

Thanks
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-25-2008
Junior Member
  
Join Date: Jun 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
kutam is on a distinguished road
Re: Integrating Excel with QTP
You can't insert your testcases in QTP directly. only input data can be done. You have to upload to MQC only.

-Kutam
Software Testing Forum • Portal
Reply With Quote
  #3 (permalink)  
Old 07-01-2008
Junior Member
  
Join Date: Jul 2007
Location: CA
Posts: 16
Thanks: 2
Thanked 5 Times in 4 Posts
Fahed9090 is on a distinguished road
Re: Integrating Excel with QTP
I totally agree with Kutam
Reply With Quote
  #4 (permalink)  
Old 07-10-2008
Junior Member
  
Join Date: Jul 2008
Location: PUNE
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
sreekiran2007 is on a distinguished road
Re: Integrating Excel with QTP
hi,
this is sreekiran i had a problem whiel multiplication and addition.I write the script as follow
systemutil.Run "C:\WINDOWS\system32\calc.exe"
dialog("text:=Calculator").Activate
dialog("text:=Calculator").WinButton("text:=2").Click
dialog("text:=Calculator").WinButton("text:=*").Click
dialog("text:=Calculator").WinButton("text:=2").Click
dialog("text:=Calculator").WinButton("text:==").Click

it is displaying error so can anybody correct this and what is the problem while giving the symbols for multiplication and addition
Reply With Quote
  #5 (permalink)  
Old 07-10-2008
Expert Member
  
Join Date: Jan 2007
Location: India
Posts: 144
Thanks: 3
Thanked 11 Times in 11 Posts
NawabShaikh is on a distinguished road
Question Re: Integrating Excel with QTP
1. Spy out the calc and check what QTP Expect, code accordingly.

2. Use '\' for special characters.


Regards,
Nawab
Reply With Quote
Reply

  Geeks Talk > Software Testing > QTP

« qtp8.2 | creating a new folder by qtp »

Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
Integrating IBM Rational Functional Tester (RFT) radhakrishnan.tt Quality Center 1 4 Weeks Ago 06:37 AM
Integrating Quality Center with SilkTest sajithkutty Quality Center 0 06-01-2008 03:00 PM
Excel srinii_vasu Testing Issues 2 02-22-2008 11:12 PM
Read excel values into script without opening excel nemishdmehta QTP 1 02-11-2008 06:19 AM
Integrating PHP with VXML abhigs PHP 0 09-22-2007 01:34 AM


All times are GMT -4. The time now is 09:01 AM.

Contact Us - Geeks Discussions - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved