QTP and Excel Part3

11 Comments

1. senthilkumar on Feb 19, 2015 at 21:32

   Hi Ankur,

   The Methods which can be used with DataTable Object is not clearly visible. Can we have a clear image of it.

   Regards,
   Senthil

   Reply
2. ruchi on Sep 9, 2013 at 21:55

   Hi Ankur..this blog seems really helpful. but this image is not visible at all..could you please prove a clear image so that I can read all the functions….

   Thanks.

   Reply
3. Anonymous on Jan 16, 2012 at 15:42

   Hi,

   How to parameterize the Local sheet values in QTP11.0.

   Action call properties is disabled in qtp11.0

   Regards,
   Jeya

   Reply
4. anjalivaswani on Aug 18, 2011 at 18:02

   Hi,

   I’m new to Descriptive programming. I want to use checkpoints using Descriptive programming. Simple explain some simple examples of Text, Bitmap, Database, Text Area, Accessiblity and XML checkpoints. Your example of GUI checkpoint is very much clear to me .

   Thanks,

   Anjali vaswani

   Reply
5. Anonymous on Apr 26, 2011 at 11:25

   Dear Ankur,

   You are doing a great work dude!!!

   I have a query…Can we execute manual test cases in QTP????
   If yes …then how can we do it ?

   Regards,
   Rushali

   Reply
6. Anonymous on Sep 15, 2010 at 18:37

   Good Work Ankur,

   I have one query , how can i insert an image (Capture bitmap image) to “Action” data sheet while runnig the script?

   Reply
7. mahi on Jan 31, 2010 at 08:07

   HI Ankur,
   Your blogs here really helps.
   I have a doubt and need help for u
   if i have username and password and click on lopin button the next will come i want script for this and this is very but i want message if username and password valid the next will come else next won’t come i want script

   Reply
8. Rosy on Aug 26, 2009 at 10:04

   HI Ankur,
   Your blogs here really helps.
   I have a doubt and need help in figuring out scripting few stuffs using QTP.
   1. How can i add conditional format to a excel column data without using object repository.
   2. Is there any way we can generate graphs in excel using QTP.

   Not sure how to do these.

   Thanks & regards,
   payal.

   Reply
9. Veena on Dec 10, 2008 at 10:02

   Hi Ankur,

   Its great work you are doing here…

   One question of Automating Excel as a application. We have an excel sheet which is used to upload data in Oracle. We have to automate the application ie MSEXCEL.
   We have been successful in adding data in the sheet but there is a button “upload” which when clicked calls a hidden fucntion which in turn calls a macro. the prblem is that QTP is not recognising this object in Excel…

   Right now i have created the script with manual intervention but would like to automate the complete thing if possible.

   Any pointers on the same would be helpfull.

   Thanks in advance
   Veena

   Reply
10. Ramkumar on Nov 7, 2008 at 19:08

    Hi Ankur,

    Before starting my questions, i want to thank and congratulate you for the efforts your taking to share the knowledge.

    Here my Question: I am in a Process of creating a frame work. The following are my doubts
    1. I have 3 different modules. In Module1, i have created 30 data. I want to use one of the data in Module2. My req is, I want to pass all data created in Module1 to Excel sheet and retrive the value in Module2. How to do that?
    2. I want to create my own results file in addition to the existing one. The results file (Excel) contains TestCaseID, Description, Pass/Fail, Comments Columns. After executing each test case, i want to pass these values into excel (say 30 cases means 30 rows in excel) how to achieve this.

    Your help is much appreciated.

    Thanks a lot.
    Ram
    (QTP BLOG FAN)

    Reply
11. qtplearner on Feb 12, 2008 at 23:58

    hi ankur

    i have a doubt how i write result using excel file and append the results in ane row
    i dont want to use reporterreport event
    plz help me out

    Reply