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_...>
_________________________________________________________________
Windows Live Hotmail now works up to 70% faster.
http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_faster_112008
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---