U can use QTP very much to automate data from Excel sheet wihtout any doubt.But need to focous carefully
On Thu, Jun 3, 2010 at 12:10 PM, manjunath biradar <[email protected]>wrote: > I know that the excel is the toughest application to automate and given the > changes happening in my product each day.. hectic but cant help Boss are > behind me to complete and i dont knw hw the hell i will do it.... I guess > need to make the boss understand the situation here :) > > > On Thu, Jun 3, 2010 at 6:25 AM, Roman Zilber <[email protected]> wrote: > >> Usually for automating Excel people don't use QTP. Is there special reason >> you don't use automation with COM? >> >> On Wed, Jun 2, 2010 at 2:06 AM, manjunath biradar < >> [email protected]> wrote: >> >>> Hi Abhijeet, >>> >>> Below are the details of the automation i am working on... >>> >>> QTP version : 9.5 >>> Excel 2007 >>> OS: WinXp >>> >>> >>> On Tue, Jun 1, 2010 at 12:28 PM, Abhijeet <[email protected]>wrote: >>> >>>> Hi Manjunath, >>>> >>>> My answer here is based on what I worked on. I don't know upto what >>>> extent you have automated this application. So, some of the points >>>> here may also be redundant / useless to you. >>>> >>>> 1. The automation strategy will depend on office version also. Which >>>> version of excel / office are you using ? The reason for this question >>>> is office 2007 is way different than the office XP, and needs >>>> different ways of navigating. >>>> >>>> For the navigation purposes, it's always best to use the shortcut keys >>>> for automation. Let's assume the addin has the shortcut of "ALT+X+P" >>>> to be able to navigate. You can notice the difference, in office 2007, >>>> you just have to press ALT key once, and release, and then you can >>>> press X and P as and when required. You don't have to hold on to the >>>> ALT key. In office XP version, you have to hold on to the ALT key >>>> until you are done. >>>> >>>> 2. WPF : Are you using QTP 9.5 or 10 ? Ideally it should be QTP 10. Do >>>> you have the latest patch installed ? The latest patch is called >>>> something like "patch 38" (QTPNET_00038).I don't have it's proper name >>>> right now. Also, make sure that you refer to the documentation of the >>>> patch, as for this patch it is required that a particular patch (I >>>> believe QTPNET_00015) for wpf SHOULD NOT be present while installing >>>> this new patch. >>>> >>>> Please check the link : >>>> http://www.sqaforums.com/showflat.php?Cat=0&Number=625380&an=0&page=0 >>>> >>>> Also try to find out from the HP resource center if they have any new >>>> patch for WPF. They keep on releasing new patches regularly based on >>>> tickets. If you are facing problems about QTP identifying some objects >>>> properly and not the others, chances are some of the object >>>> properties / methods are not exposed by the developers, and if it is >>>> proper, then you can work with HP to open up a ticket. >>>> >>>> - Abhijeet >>>> >>>> >>>> On May 31, 1:26 pm, manjunath biradar <[email protected]> wrote: >>>> > Hi, >>>> > >>>> > I am facing a peculiar problem.. I have an add-in in the excel to be >>>> > automated and when i try object identification i am able to see only >>>> the >>>> > "Book1" being recognized and everything else is identified as an >>>> object. I >>>> > have the wpf addin with licensed version but no luck... >>>> > >>>> > The addin is built with Wpf objects. Even tried creating a new object >>>> set by >>>> > selecting Wpf standard object but no luck, >>>> > >>>> > So can one please advise on this.. as i have a very tight deadline to >>>> > finish. :) >>>> > >>>> > Cheers >>>> > Xpressmusic >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> "QTP - HP Quick Test Professional - Automated Software Testing" >>>> group. >>>> To post to this group, send email to [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected]<mercuryqtp%[email protected]> >>>> For more options, visit this group at >>>> http://groups.google.com/group/MercuryQTP?hl=en >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> "QTP - HP Quick Test Professional - Automated Software Testing" >>> group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected]<mercuryqtp%[email protected]> >>> For more options, visit this group at >>> http://groups.google.com/group/MercuryQTP?hl=en >>> >> >> -- >> You received this message because you are subscribed to the Google >> "QTP - HP Quick Test Professional - Automated Software Testing" >> group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected]<mercuryqtp%[email protected]> >> For more options, visit this group at >> http://groups.google.com/group/MercuryQTP?hl=en >> > > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<mercuryqtp%[email protected]> > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
