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