Try using value at the end
Blah = excel.worksheets(4).Range(B2:J2).Value
puts Blah
On Dec 1, 12:46 pm, [EMAIL PROTECTED] wrote:
All,
I am trying to enter the contents of an array into an excel range.
Here is a sample of what I am doing now:
array = (0,1,2)
excel.Range(A1::A3) = array
:57 -0800 Subject: [wtr-general] Re:
Excel Ranges and Ruby From: [EMAIL PROTECTED] To:
watir-general@googlegroups.comTry using value at the end Blah =
excel.worksheets(4).Range(B2:J2).Value puts Blah On Dec 1, 12:46 pm,
[EMAIL PROTECTED] wrote: All, I am trying to enter the contents
I just tried your code on my machine, and I am still getting a 1 in all three
cells.
- Shelton Date: Mon, 1 Dec 2008 11:27:28 -0800 Subject: [wtr-general] Re:
Excel Ranges and Ruby From: [EMAIL PROTECTED] To:
watir-general@googlegroups.com I got this to work. excel =
WIN32OLE.connect
@googlegroups.com
Subject: [wtr-general] Re: Excel Ranges and Ruby
I just tried your code on my machine, and I am still getting a 1 in all
three cells.
- Shelton
Date: Mon, 1 Dec 2008 11:27:28 -0800
Subject: [wtr-general] Re: Excel Ranges and Ruby
From: [EMAIL PROTECTED]
To: watir
]:
[wtr-general] Re: Excel Ranges and Ruby
I just tried your code on my machine, and I am still getting a 1 in all three
cells. - Shelton Date: Mon, 1 Dec 2008 11:27:28 -0800 Subject:
[wtr-general] Re: Excel Ranges and Ruby From: [EMAIL PROTECTED] To:
watir-general@googlegroups.com I got
Of
Jason SheltonSent: Monday, December 01, 2008 2:46 PMTo: [EMAIL PROTECTED]:
[wtr-general] Re: Excel Ranges and Ruby
No, I am using the same cell range. a1 - a3 is being populated on my machine,
but it is populating each cell with element 0 in my array, not element 0, 1,
and 2. -Shelton
