How to Import the data from MS-Excel in QTP?

[bizzzzzare]

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...

[QTP_Auto]

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...

I've a question for bizzzzzare: Per your mention above(highlighted in red)Can you please guide me with creating an array of all the rows matching specified criteria by continously looping through the used range in an external excel sheet instead of the datatable.

I'll really appreciate it.
Thanks.

[QTP_Auto]

Hi bizzzzzare! I've a question for you: Can you please tell me how can I create an array to continously loop through an excel sheet and read all required values. I'd really appreciate it. Thanks. I'm in the constant process of learning coding in QTP.

[mr.jsrao]

datatable.AddSheet("AAAA")
datatable.ImportSheet "D:\shiva\other\Keyword.xls","AA","AAAA"
rc=datatable.GetSheet("AAAA").GetRowCount

msgbox rc

For i=1 to rc
datatable.GetSheet("AAAA").SetCurrentRow(i)
a=datatable.Value("shiva","AAAA")
msgbox a
Next

[mr.jsrao]

Hi any one tell me that how to make word gabling??? shiva--->vasih (or) ivahs like this???