Pls

Anyone tell me How to import a single data from the Excel in QTP.

Give me exact coding for the sample flight application......

Hi ramyamca1984

For import the data from excel in QTP you have to write one line on the top of your qtp script and that is:

DataTable.Importsheet"C:\Path name(Ex:Mar_Qtp)\Excelsheet name(Ex:abc.xls)",1,Global

Now run the script.While run time you can see the import data on you data table in QTP.

Hope It will help you
Newhere

Hi,

As Ramya suggested Importing data from excel sheet into your datatable can be achieved.

But incase you wish to read Excel values into your script, try this....

dim sExcelObj
dim sWorkBook
dim sWorkSheets
dim sValue

set sExcelObj = CreateObject("Excel.Application")
sExcelObj.Visible = true
set sWorkBook = sExcelObj.Workbooks.Open ("path of file")
set sWorkSheets = sWorkBook.ActiveWorkbook.worksheets ("sheetname")

sValue = sWorkSheets.cells(row,col).value

You can also create an array to continously loop through your excel sheet and read all required values.

Cheers...

__________________
Regards,

V.Umesh Krishnan
QA Consultant

Hi,
I am new to QTP. I did like you explained. But it is not working.What happening here is, always script is running from first line means, Next iteration also running from first line.Every time it is taking value from from first row of excel sheet. It is not going to second line. Please explain me, how to reach next row.
Thanks in advance

Pls tell How to Import the data from MS-Access in QTP?

hi thatiper
QTP records your actions on the application in the form of vbscript
now once the recording has been done ...usually we enhance the code accoring to our requirements and need by modifying using control constructs in the script
we add few lines of code too ..to make QTP behave as desired

In general if you want QTP to iterate over all rows in datatable then go to
file> settins > Run and check on the radiobutton "run on all rows"
probably you willl be able to solve the problem
hope the iteration doesn't become indefinite

its as simple as this....

To add a sheet
datatable.addsheet("sheetname")

To import sheet datatable.importsheet "c:\excelfile.xls", "sheet1"

To get a value form excel file..
Empno = datatable.value("empno", "sheet1")

To run the script for all the iterations..
For i = 1 to datatable.getsheet("sheet1").getrowcount
msgbox datatable.value("empno", "sheet1")
Next

OR

For i = 1 to datatable.getrowcount
datatable.setcurrentrow(i)
datatable.getcurrentrow
msgbox datatable.value("empno", "sheet1")
datatable.setnextrow
Next

can any body show me the test script for functional testing in qtp on any topic