[wtr-general] Re: How to read data from excel sheet

2009-01-26 Thread JArkelen
Here is an example of opening an Excel file and looping through rows and colums: # Get data from start.xls based on computername application = WIN32OLE.new('Excel.Application') if (File.exists?('V:\\QA\\WTM\\WTM.rb'))

[wtr-general] Re: Issue with using arguments within Open Office (column, row) code

2009-01-26 Thread dmitry...@gmail.com
Hi Alister, I've already started playing around on ways to implement roo in there. Thank you. On Jan 23, 6:27 am, Alister Scott wrote: > This is probably a lot easier if you use Roo. > Full details available here:http://roo.rubyforge.org/ > An example on how to read OpenOffice > here:http://wa

[wtr-general] Re: ie.contains_text problem

2009-01-26 Thread Michael Hwee
Or, ie.text_field(:value, 'FOO').exists? Monkeybun, please make sure you asked the right question after your investigation. So, we can help you solved your problems properly. Michael - Original Message From: dara To: Watir General Sent: Friday, January 23, 2009 3:13:11 PM Subject

[wtr-general] Re: ie.contains_text problem

2009-01-26 Thread Monkeybuns
Thanks to all for your help. I've tried the three solutions suggested in the previous two replies. The last one found the text field value FOO, the first two did not. I put the following code in my script: ie = Watir::IE.attach(:title, "FooBar Report") if assert(ie.text_field(:id,'ctl140_ctl00

[wtr-general] Re: How to read data from excel sheet

2009-01-26 Thread Tiffany Fodor
You can also use David Brown's Xls class to get data from a spreadsheet: http://wiki.openqa.org/display/WTR/Excel+interface+class Hope this helps! -Tiffany On Jan 24, 1:52 am, malar b wrote: > hi, > i need to read data from an excel sheet and substitute those data into > text_field's in a web

[wtr-general] Re: ie.contains_text problem

2009-01-26 Thread Monkeybuns
Success! I eliminated the asserts. Thanks for help, everyone. ie = Watir::IE.attach(:title, "FooBar Report") if ie.text_field(:id,'ctl140_ctl00_ctl09_txtValue').value == 'FOO' puts "FOO Found" else puts "FOO Not Found" end if ie.text_field(:name,'ctl140$ctl00$ctl09$txtValue')

[wtr-general] Integration with Rally

2009-01-26 Thread Pete Dignan
This message may be of interest to anyone using Rally http://www.rallydev.com to manage their agile process. I met on 1/20 with three folks from Rally: CTO Ryan Martens, Zach Nies (VP of Product Development) and Bob Cotton (http://awta.wikispaces.com/ Bob+Cotton) to talk about Watir and Rally. T

[wtr-general] Re: Watir on Solaris

2009-01-26 Thread Tiffany Fodor
Thanks Bret, Charley and Al! I've passed all your information on to my friend. Hopefully she can get a new Watir project going! -Tiffany On Jan 24, 3:36 pm, Bret Pettichord wrote: > I concur. If you have a Solaris box and know how to compile code (i.e. > know something about C/C++ development

[wtr-general] Controlling JavaScript Pop Ups without .click_no_wait

2009-01-26 Thread Bill Mosteller
The application situation is that the user is about to discard unsaved work. A dialog box appears titled "Windows Internet Explorer" saying "Are you sure you want to delete the selected Email?" with buttons "OK" and "Cancel". I thought my prayers were answered for this when I found: http://wiki.

[wtr-general] Re: Access Denied Error

2009-01-26 Thread JArkelen
But when you iframe source is coming from a totally different source you really have a problem though. I solved it with trying and using a different proxy in our company. On Jan 23, 4:10 pm, LFIdnl wrote: > I had the same problem. It reproduce if url of main application and > url of frame are no