QTP Excel File Scripts

Bharat_aus · 29-09-08, 06:34 AM

Hi All,

Can Any one post sample code to read and write test data to external excel file using QTP

butair · 30-09-08, 10:20 PM

Try posting your querry to: QTP Beginners

I believe you'll get your answer there.

saran_s85 · 03-10-08, 01:06 PM

Hi,

Set oexcel = CreateObject("Excel.Application")
Set obook = oexcel.Workbooks.Open("D:\sample.xls")

' Writing values into excel sheet

oexcel.Cells(1,2) = "QTP"
oexcel.Cells(1,3) = "Automation"

'Reading values from excel sheet

strvar1 = oexcel.Cells(1,2)
strvar2 = oexcel.Cells(1,3)

obook.Save
obook.Close

I hope this code will help you

Simran06 · 11-12-08, 02:38 AM

I want to copy some rows in an excel sheet to another excel sheet like A1.xls to A2.xls and rows which i want to copy are like “B8:Z8″, "B15:Z:15" and "B22:Z22" and so on. In the following code below:

objworksheet.Range ("B8:Z8")

I would like to enter dynamic values in “Range” field like first time the script will copy the Range “B8:Z8″ and second time “B15:Z15″ and so on. So I would like to make the script dynamic. Is there any way can I do it or using loops etc.? please help me out.

Thanks.

29-09-08, 06:34 AM	#1 (permalink)
Bharat_aus Junior Member Join Date: Sep 2008 Age: 27 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 2	QTP Excel File Scripts Hi All, Can Any one post sample code to read and write test data to external excel file using QTP
Offline

30-09-08, 10:20 PM	#2 (permalink)
butair Member Join Date: Feb 2008 Age: 46 Posts: 92 Thanks: 17 Thanked 3 Times in 3 Posts Rep Power: 2	Re: QTP Excel File Scripts Try posting your querry to: QTP Beginners I believe you'll get your answer there.
Offline

03-10-08, 01:06 PM	#3 (permalink)
saran_s85 Junior Member Join Date: Jun 2008 Age: 24 Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 2	Re: QTP Excel File Scripts Hi, Set oexcel = CreateObject("Excel.Application") Set obook = oexcel.Workbooks.Open("D:\sample.xls") ' Writing values into excel sheet oexcel.Cells(1,2) = "QTP" oexcel.Cells(1,3) = "Automation" 'Reading values from excel sheet strvar1 = oexcel.Cells(1,2) strvar2 = oexcel.Cells(1,3) obook.Save obook.Close I hope this code will help you
Offline

11-12-08, 02:38 AM	#4 (permalink)
Simran06 Junior Member Join Date: Dec 2008 Age: 28 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: QTP Excel File Scripts I want to copy some rows in an excel sheet to another excel sheet like A1.xls to A2.xls and rows which i want to copy are like “B8:Z8″, "B15:Z:15" and "B22:Z22" and so on. In the following code below: objworksheet.Range ("B8:Z8") I would like to enter dynamic values in “Range” field like first time the script will copy the Range “B8:Z8″ and second time “B15:Z15″ and so on. So I would like to make the script dynamic. Is there any way can I do it or using loops etc.? please help me out. Thanks.
Offline

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MANUAL TESTING CONCEPTS (pdf)	ramkumarbtech	Testing Tools & QA	17	16-11-09 01:08 PM
Mega Free Download S/W Links A-Z	yathish	OTHERS	516	21-03-09 10:06 AM
HACK WITH MS DOS	__wicked__	SYSTEM SECURITY & ETHICAL HACKING	1	14-12-08 10:21 PM
interview Q&A asked in winrunner	Spoorthi	Testing Tools & QA	80	22-11-08 11:48 PM
C Contest-28	keerthi	DATA STRUCTURES, C, C++, VC ++	6	01-07-06 10:04 PM