'programme to transfer the data from notepad to excel Dim fso,myfile,

Create an Excel file and pass the values from Flat File? (for ex:data1.txt,data2.txt )

Question Posted / prashant puranik

2 Answers
3497 Views
FIS, I also Faced
E-Mail Answers

Answer Posted / prashant puranik

'programme to transfer the data from notepad to excel
Dim fso,myfile,i,row
i=1,row=0
Set fso=Createobject("Scripting.filesystemobject")
Set myfile=fso.OpenTextFile("G:QTP Examplesqtpexamplefile2.txt",1,True)
Datatable.AddSheet("Puranik")
Datatable.GetSheet("Puranik").AddParameter "Prashant" ," "
Do While myfile.AtEndOfStream <> true
row=row+1
Datatable.GetSheet("Puranik").SetCurrentRow(row)
Datatable.Value("Prashant","Puranik")=myfile.ReadLine
Loop
Datatable.Export("G:QTP Examplesqtpexample_file1.xls")

'Programme to transfer the data from excel file to notepad
Dim fso,i,myfile
Datatable.AddSheet("mysheet")
Datatable.ImportSheet "G:QTP Examplesqtpexample_file2.xls","Sheet1","mysheet"
row=Datatable.GetSheet("mysheet").GetRowCount
Set fso=Createobject("Scripting.filesystemobject")
Set myfile=fso.OpenTextFile("G:QTP Examplesqtpexamplefile3.txt",2,True)
For i=1 to row
Datatable.GetSheet("mysheet").SetCurrentRow(i)
myfile.WriteLine(Datatable.Value("Anuj","mysheet"))
Next
Set myfile=nothing
Set fso=nothing

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does QTP identify an object?

1045

Explain the features and benefits of quick test pro(qtp)?

977

Which environments does qtp support?

1108

What are the data types in qtp?

1124

Plz Explain AUTOMATION REFERENCE MODEL?

2223

What are parameterizing tests?

1042

In what occasion we can specify global sheet and action sheet?

1036

how u will evaluate the tool for test automation?

1861

why should we give deliver good quality software?

2123

how do u plan test automation?

1917

There is an excel file of 1 to 100 sheets how you will iterate through it?

1006

If I change the property value at runtime is it effect is object repository?

1095

What are the types of data tables in qtp?

1010

Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.

3508

Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ

2037