You can use .text instead of .Value.
Here's some reference material for using ruby with excel:
http://rubyonwindows.blogspot.com/search/label/rubygarden

On Tue, Jan 27, 2009 at 12:26 AM, <magn...@ifi.uio.no> wrote:

>
> Hello, I am using WatiR as webtesting tool and I have seperated the
> data onto a Excel file and I am using the following to connect the
> workbook with testdata to the Watir script:
>
>
> require 'win32ole'
>
> excel = WIN32OLE::new("excel.Application")
> workbook = excel.Workbooks.Open("C:\\Programfiler\\Ruby\\FPSdata.xls")
> worksheet = workbook.WorkSheets(1) # get first workbook
> value = worksheet.Range("b2").Value # get the value at cell b2 in
> worksheet.
>
> In the last line "b2" refers to a number in a Excel cell with a numer
> (1200).
>
> Executing the script this error message occurs:
>
>
> :/ruby/lib/ruby/gems/1.8/gems/watir-1.6.2/lib/watir/input_elements.rb:
> 390:in `limit_to_maxlength': undefined method `length' for
> 1200.0:Float (NoMethodError)
>
>
> It seems like
> "value = worksheet.Range("b2").Value"
> doesn't support the format in the Excel cell, because when I try to
> get another value that is a string  i.e. "John"
> it works fine.
>
> Do I need to convert to string?
>
> How would you write the code:
> "value = worksheet.Range("b2").Value"
> with the toString in Ruby to_s?
>
>
> I hope someone can help me!
>
>
> Cheers
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to