Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Automating Excel Formulaes

This is a discussion on Automating Excel Formulaes within the QTP forums, part of the Software Testing category; Can we automate the process of performing some Excel Formulaes (like concatenating columns,adding columns) through QTP. If so then how ? NOTE : [This question was asked by Satish, I am ...

Geeks Talk > Software Testing > QTP Automating Excel Formulaes

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   12-16-2006

JobHelper Expert Member   Join Date: Oct 2006 Posts: 690 Thanks: 0 Thanked 49 Times in 41 Posts

Automating Excel Formulaes Can we automate the process of performing some Excel Formulaes (like concatenating columns,adding columns) through QTP. If so then how ? NOTE : [This question was asked by Satish, I am posting it in proper forum]

Sponsored Links

#2 (permalink)   12-19-2006

schittoor Junior Member   Join Date: Mar 2006 Location: Chennai Posts: 11 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Automating Excel Formulaes In QTP cannot perform the excel commands. but we can do the same commands from different ways through VB-Script. Thanks Srinivasulu.Chittoor

#3 (permalink)   02-19-2008

jainbrijesh Moderator   Join Date: Sep 2006 Location: Delhi (India) Posts: 865 Thanks: 12 Thanked 81 Times in 65 Posts

Re: Automating Excel Formulaes Quote: Originally Posted by JobHelper Can we automate the process of performing some Excel Formulaes (like concatenating columns,adding columns) through QTP. If so then how ? NOTE : [This question was asked by Satish, I am posting it in proper forum] Yes we can do it using Data table. __________________ Brijesh Jain brijesh.tester@yahoo.co.in http://softwaretestingexpertise.blogspot.com

Geeks Talk > Software Testing > QTP

« WebEdit and WebList | ExternObject »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
reading data from excel sheet in QTP	JobHelper	QTP	4	09-11-2007 07:33 AM
100 test cases from TD into an excel sheet	Lokesh M	Test Director	2	12-23-2006 04:20 AM

All times are GMT -4. The time now is 05:19 AM.