Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


hey please tell me how to retriev data from excel sheet
which puts the login name and password in the application?
plz send me the code..please help me

Answers were Sorted based on User's Feedback



hey please tell me how to retriev data from excel sheet which puts the login name and password in ..

Answer / siri

set ex= CreateObject("Excel.Application")
set wrkbk= ex.workbooks.open(excelbookpath)
set objDriverSheet=wrkbk.worhsheets("Sheetname")

dim lgin,pwd,row
for i=0 to 5
row=i
lgin=objDriverSheet.Cells(row,"A")
pwd=objDriverSheet.Cells(row,"B")
msgbox lgin
msgbox pwd

next

Is This Answer Correct ?    3 Yes 0 No

hey please tell me how to retriev data from excel sheet which puts the login name and password in ..

Answer / bfakruddin

option explicit
dim xl,rc,UserID,pwd

set xl=createobject("excel.application")
xl.visible=true
xl.workbooks.open "path of your excel sheet"
xl.sheets("Sheetid").select
rc=xl.sheets("Sheetid").usedrange.rows.count
for i=0 to rc
UserID=xl.cells(i,1) 'here 1 is column no.userid contai
pwd=xl.cells(i,2) 'here 2 is column no. password contain
object.set UserID
object.set pwd
Next

Is This Answer Correct ?    1 Yes 0 No

hey please tell me how to retriev data from excel sheet which puts the login name and password in ..

Answer / sojan davis

IF using QTP tool, you can use Import Function

Datatable.ImportSheet "C:\.\.\Data.xls","Sheet1","Global"

Is This Answer Correct ?    0 Yes 0 No

hey please tell me how to retriev data from excel sheet which puts the login name and password in ..

Answer / manjunathareddy

Set oExcel=CreateObject("Excel.Application")
Set oBook=oExcel.Workbooks.Open(Excelpath)
Set oSheet=oBook.Worksheets(Excelsheetnumber)
oRow=oSheet.Usedrange.Rows.Count
For i=2 to oRow
Un=oSheet.Cells(i,1).Value
Pwd=oSheet.Cells(i,2).Value
Msgbox Un
Msgbox Pwd
Next

Is This Answer Correct ?    0 Yes 0 No

hey please tell me how to retriev data from excel sheet which puts the login name and password in ..

Answer / rajani_kanth

Option explicit
Dim objExcel,objExcelSheet,row,col,i,j

Set objExcel=CreateObject("Excel.Application")
objExcel.Workbooks.Open("D:QTPdata.xlsx")
'objExcel.Application.Visible=true
Set objExcelSheet=objExcel.ActiveWorkbook.Worksheets("Sheet1")


row=objExcelSheet.UsedRange.Rows.count
col=objExcelSheet.UsedRange.Columns.count


For i= 2 to row
For j= 1 to Col
' Print objExcelSheet.cells(i,j).value

InvokeApplication"C:Program Files (x86)HPQuickTest Professionalsamplesflightappflight4a.exe"
wait 1
dialog("Login").WinEdit( "Agent Name:").Set objExcelSheet.cells(i,j).value
wait 1
J=J+1
dialog("Login").WinEdit("Password:").Set objExcelSheet.cells(i,j).value
WAIT 1

DIALOG("Login").WinButton("OK").Click
wait 1
window("Flight Reservation").Close
wait 1

Next

Next


objExcel.Workbooks.Close
objExcel.Quit
Set objExcelSheet=Nothing

Set objExcel=Nothing

Is This Answer Correct ?    0 Yes 0 No

hey please tell me how to retriev data from excel sheet which puts the login name and password in ..

Answer / chakkara

you can do like this:
1. import the data into local sheet from excel
datatable.ImportSheet "path of the excel file",1,"local
sheet name"

2. assign the values to the fields

browser("").Page(" ).WebEdit(" ).Set datatable("UserName",
dtlocalsheet)

Is This Answer Correct ?    0 Yes 2 No

Post New Answer



More VB Script Interview Questions

There is a web Table where You will find Two Columns First Column consist of Check box and Second column consist of Test cases ID(Viz T1,T2,T3....Etc); If You select any Test case ID, respective Check boxes to be checked write a VBSCRIPT for this scenario?

1 Answers   eMids,


1. How to handle object implementation change in DP for Ex: i have login page with username,pasword (editboxes),login,cancel(buttons). Here i written DP code for login page with the help properties. My questions: 1.If properites are changing dynamically i will do (i want code for that) 2.if objects are changed dynamcally i will do (i wnat code for that)

0 Answers   iFlex,


What are string functions in vbscript?

0 Answers  


What is the difference between javascript and vbscript?

0 Answers  


What is loose binding? Why is it not a good practice to use it?

0 Answers  






this q asked in applabs, q is: QTP should open google.com page and enter "qtp" in one edit(search) box and click search and should open google.com again and enter "job" in edit(search) box and click on search. I tried this but getting error "Edit(search) box matches more than one object", could anyone this question plz..

1 Answers   AppLabs,


how to retrieve native property value in runtime?

1 Answers   Hexaware,


how to find the textfile in the folder and copy file from one folder to another folder useing parameterigation in QTP

1 Answers   Accenture,


How to take whole text output from screen of Bitmap Application.

0 Answers   CitiGroup,


Write a program to create a Dynamic array of size 5 elements and display all the elements.

1 Answers  


how to find number of characters(letter a) in the sentence Rain Rain Go away

4 Answers  


What is vbscript procedures?

0 Answers  






Categories