Answer Posted / prashant puranik

'To transfer the data from flat file to excel. I have used a logic as Flatfile to datatable 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")
Set myfile=nothing
Set fso=nothing


'Similary i have created i logic to transfer the data from excel to notepad file

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

if anyone has idea of the interview procedure in covansys, plz send me a mail?

2040

---

How to creating an output value using quicktest professional (qtp)?

1061

---

Explain about datafile/verification of date file when file is not available in local system?

2784

---

How do I get the QTP scripts result in xml format by using vb script function?

2334

---

How to create scenario selector

2197

---

How do I lauch my test website using code from qtp in different environmet, uat and PPTE?

2076

---

Problem with XML checkpoint in QTP ?

3980

---

requirement is for combo box your expected value is str= "Denver.Frankfurt.London.Los Angeles.Paris.Portland.San Francisco.Seattle.Sydney.Zurich" you must get the text in combo box and need to compare them how

2063

---

How to test background color and dynamic images during run time can you put the check point for moving objects?

1965

---

what is the difference between data driver & data driven and driver script?

2803

---

what is the frame work in J-meter?

2202

---

Explain the qtp test phases.

1088

---

Hi Frenz... I would like to take up the QTP certification . Can anyone tell me what is the procedure. n if anybody have the study materials pls fwd it to jkpunathil@gmail.com

2022

---

What is the differences between image check point and bit map check point?

1135

---

What is the architecture of your project? Can any one answer for this question plz........

1929

---