Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
import form excel file
#6
Not Solved
no, global sheet in datatable is null, all records are stored in excel file
this is all of scripts in my project:
Code:
Datatable.Import("D:\Software Quality Control\pncbookstore\Login.xls")

Browser("Browser").Page("Online").Link("Login").Click
Browser("Browser").Page("Login_Online").WebEdit("user_login").Set DataTable("user", dtGlobalSheet)
Browser("Browser").Page("Login_Online").WebEdit("user_login").SetTOProperty "value", DataTable("user", dtGlobalSheet)
strMail = Browser("Browser").Page("Login_Online").WebEdit("user_login").GetTOProperty("value")
Browser("Browser").Page("Login_Online").WebEdit("password").SetSecure "3c32f2445bbc7481db3492b1d1556ceb7fdf9e03ca7be253143d"
If strMail = "d_quangvu@yahoo.com" Then
    Browser("Browser").Page("Login_Online").WebButton("Login").Click
    Browser("Browser").Page("Online").Link("Logout").Click
else
    reporter.ReportEvent micFail, "Failed Report","..."
End If
Browser("Browser").Close
Reply


Messages In This Thread
import form excel file - by sekhan - 10-10-2010, 02:50 PM
RE: import form excel file - by venkatbatchu - 10-10-2010, 05:27 PM
RE: import form excel file - by A.Saini - 10-10-2010, 09:16 PM
RE: import form excel file - by sekhan - 10-11-2010, 07:09 AM
RE: import form excel file - by A.Saini - 10-11-2010, 09:35 AM
RE: import form excel file - by sekhan - 10-11-2010, 02:50 PM
RE: import form excel file - by sekhan - 10-20-2010, 12:50 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to export the output value of a webedit object to a new excel file. mounika6677 1 1,534 04-14-2019, 05:18 PM
Last Post: mounika6677
  Access not saved excel file randhirsinghskhn 0 1,041 09-04-2018, 07:26 AM
Last Post: randhirsinghskhn
  Can we test Salesforce Standard form using QTP? yona34 0 1,079 05-22-2018, 10:57 AM
Last Post: yona34
  dtLocalSheet empty even though excel file contains data cantorre 2 2,434 05-10-2017, 12:47 PM
Last Post: vidhi
  How import final calculated values by cell formula from Excel not the formula itself. qtped 1 4,871 01-17-2017, 04:05 PM
Last Post: sagar.raythatha

Forum Jump:


Users browsing this thread: 1 Guest(s)