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 RubyDate: Mon, 1 Dec 2008 14:41:20 -0600From: [EMAIL PROTECTED]: 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 SheltonSent: Monday, December 01, 2008 2:36 PMTo: [EMAIL PROTECTED]: [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_________________________________________________________________ Proud to be a PC? Show the world. Download the “I’m a PC” Messenger themepack now. hthttp://clk.atdmt.com/MRT/go/119642558/direct/01/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---