Answer / rajesh

Set objInputDataxlsFile=createobject("Excel.Application")
objInputDataxlsFile.workbooks.open <File_name_Path>,true,true
Set
currentworksheet=objInputDataxlsFile.Activeworkbook.Worksheets(1)
UserID = currentworksheet.cells(1,3).value
Password1=currentworksheet.cells(2,3).value
Status = fnLogin 'Call to login function
currentworksheet.cells(4,3).value= Status

Answer / madhavi

We can create an excel object i qtp and then export or
import data.

Answer / tvs ramakrishna chowdary

sorry ur queston is not proper again post question properly

then i can give answer

Answer / tvsrkc

we can import data from excel sheet but not export syntax
as follows

datatable.import("d:\sampls.xls")

we can export data from qtp to excel file by using
following syntax

datatable.export("path")

in both situations export/import runtime datatable takes
place

hi all can any body explain how to write the script for finding the mandatory fields which are having [red Astrik sign (*)]

0 Answers   Accenture,

---

What is the main disadvantage of using low level and Analog modes?

2 Answers  

---

In qtp,how to interact tool & application build?

1 Answers   Polaris,

---

Cn u please clarify my doubt Where are micTab and micReturn used.Thanx in Advance

2 Answers  

---

in flight reservation ex once u login, u go into next window where we hav an option of new, open and help etc.. how to fetch those options and to go to respectiv tab accordingly using qtp.. plz let me knw answer for tis as early as possible. Thanks in advance... asha

1 Answers  

---

If a script has a local repository and also uses a shared repository, which repository will QTP use first when searching for an object during playback?

3 Answers  

---

wht is the difference betn check point and output value?

5 Answers   BirlaSoft,

---

what is difference between analog and low level recording

2 Answers   Intel,

---

synchronization, wait,wait Property?

1 Answers  

---

What is the logic for reading(exporting)the data from flat files to QTP?Can anyone explain me with an example? I appreciate it!!! Thanks!!! Prasanna

1 Answers  

---

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

0 Answers  

---

What are the QTP advantages and disadvantages?

6 Answers  

---