Yeah that makes sense. I don't mind contributing to your minds at
all.
Here is how I've implemented the .ods data file read between two
scripts.
firstscript.rb:
require 'secondscript'
class FirstScript
def testone(x, y)
#these control the columns within the .ods file
i = #{y + 1}
j = #{x + 1}
k= #{x + 2}
l = #{x + 3}
noArgs = []
file_uri = "file:///c:/test.ods"
serviceManager = WIN32OLE.new("com.sun.star.ServiceManager")
coreReflection = serviceManager.createInstance
("com.sun.star.reflection.CoreReflection")
desktop = serviceManager.createInstance("com.sun.star.frame.Desktop")
spreadsheet = desktop.loadComponentFromURL(file_uri, "_blank", 0,
noArgs)
sheetsCollection = spreadsheet.Sheets
sheet1 = sheetsCollection.getByIndex(0)
$browser.text_field(:id,'position1').value = sheet1.getCellByPosition
(i, j).Formula
sleep 2
$browser.text_field(:id,'position2').value = sheet1.getCellByPosition
(i, k).Formula
sleep 2
$browser.text_field(:id,'position3').value = sheet1.getCellByPosition
(i, l).Formula
sleep 2
end
SecondScript.new.testtwo([-1, 0], [-1, 1], [-1, 2])
end
secondscript.rb goes like this:
require "firstscript"
class SecondScript
def testtwo(a, b, c)
FirstScript.new.testone (*a) #The *a
controls the rows within the .ods file
FirstScript.new.testone (*b)
FirstScript.new.testone (*c)
end
end
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Watir General" group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines:
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/watir-general
-~----------~----~----~----~------~----~------~--~---
