Copy and paste this. I've tested it again and it worked.
excel = WIN32OLE.connect('excel.Application')
array = ('1,2,3').split(',')
excel.Range("A1:A3").Value = array
________________________________
From: watir-general@googlegroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jason Shelton
Sent: Monday, December 01, 2008 2:46 PM
To: watir-general@googlegroups.com
Subject: [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
________________________________
Subject: [wtr-general] Re: Excel Ranges and Ruby
Date: Mon, 1 Dec 2008 14:41:20 -0600
From: [EMAIL PROTECTED]
To: watir-general@googlegroups.com
Did you change the cell range. I was testing it on a spreadsheet where
the range a1 - a3 was populated.
DD
________________________________
From: watir-general@googlegroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jason Shelton
Sent: Monday, December 01, 2008 2:36 PM
To: watir-general@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-general@googlegroups.com
>
>
> I got this to work.
>
> excel = WIN32OLE.connect('excel.Application')
> array = ('1,2,3').split(',')
> excel.Range("B207:D207").Value = array
>
>
>
> On Dec 1, 1:11 pm, Jason Shelton <[EMAIL PROTECTED]> wrote:
> > I have been using value, I accidentally left it out of my message.
What I have looks like:
> >
> > array = (1,2,3)excel.Range("A1::A3").Value = array
> >
> > This puts a '1' into cells a1, a2, and a3. I want a1 = 1, a2 = 2,
a3 = 3. Thanks in advance for your help.
> >
> > - Shelton> Date: Mon, 1 Dec 2008 10:57:57 -0800> Subject:
[wtr-general] Re: Excel Ranges and Ruby> From:
[EMAIL PROTECTED]> To: watir-general@googlegroups.com> > > >
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> >> > When I do this cells a1, a2, and a3 are all set to 0, and
not 0,1,2 as> > I am expecting. Can someone please assist me with this?
I can> > elaborate if necessary. Thanks in advance.> >> > Shelton>
_________________________________________________________________
> > Windows Live Hotmail now works up to 70%
faster.http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_
acq_...
> </html
</html
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/watir-general
-~----------~----~----~----~------~----~------~--~---
