hi all:
I want to get values from excel,here is my code:
require 'watir'
require 'win32ole'
excel = WIN32OLE.new("excel.application")
excel.visible = true
filepath="D:\\test.xlsx"
workbook=excel.workbooks.open(filepath)
worksheet=workbook.worksheets("Sheet1")
worksheet.Select
line=1
data = []
while worksheet.Range("a#{line}")['value']
puts worksheet.Range("a#{line}")['value']
data << worksheet.Range("a#{line}")['value']
line = line + 1
end
$user=data[0]
excel.Quit
ie=Watir::IE.new
ie.maximize
ie.goto("http://192.168.1.56:37001/sso/login?service=http%3A%2F
%2F192.168.1.56%3A17001%2Fzjport%2Findex.jsp")
ie.link(:text,"XXX").click
ie.form(:id,'commonLoginform').text_field(:name,
'username').set'$user'
ie.form(:id,'commonLoginform').button(:class,'btn').click
it's my file Excel :
jiangsquall
I want to set a value(jiangsquall) to the text_field,but in fact,it
set "$user" to the text_field.
how to get the value(jiangsquall) which I want ?
--
Before posting, please read http://watir.com/support. In short: search before
you ask, be nice.
[email protected]
http://groups.google.com/group/watir-general
[email protected]
