One of my Watir scripts captures the text of a link in a page and writes it to a spreadsheet.
Here is the code:
timeSpreadsheet1 = File.new(("DataSheet") + ".xls", "w") # # File will be opened in overwrite mode.
timeSpreadsheet1.puts $ie.link(:index, 24).innerText
Another Watir script which I run subsequently accesses the data written to the spreadsheet.
Here is the code I use in this script:
#Open the Spreadsheet and grab the Opportunity Number.
excel = WIN32OLE::new('excel.Application')
workbook = excel.Workbooks.Open('C:\RegressionSuite\DataSheet.xls')
worksheet = workbook.Worksheets(1) #get hold of the first worksheet
worksheet.Select
$data = "" # The data is in cell a1.
excel['Visible'] = false # hide the spreadsheet from view
workbook.close
excel.Quit
# Insert the data read from the spreadsheet into the text field
$ie.text_field(:name, 'TEST').set $data
My script works fine and I have been able to execute my tests without issues.
But what I would like to do is to write the data in append mode instead of overwrite mode(in my first script).
Then, in my second script I would like to instruct Watir to read data from the last cell in 'a' instead of from a1, which I am currently doing.
For example, if I ran the first script 4 times, a4 would be the last cell with data in the spreadsheet. How do I instruct Watir to grab data
from the last cell(which in this case is a4) ?
_______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
