From: Daniel Navarro <djonavarro@...>
Date: 2010-11-06T04:12:14+09:00
Subject: Re: Excel and Ruby

--90e6ba6e8df64ced880494530da5
Content-Type: text/plain; charset=ISO-8859-1

Not a problem, try interpolation with a for loop.

example

for i in 1..100 do

worksheet.Range("B#{i}").value


this will loop through i or the range of 1-100. or whatever you want to loop
to.

On Fri, Nov 5, 2010 at 10:20 AM, Bev Jennings <bhjdownload@mweb.co.za>wrote:

> hi DanSr
>
> Your suggested format works like a charm (thanks so much) so I am now
> back in business and have succesfully extracted the info I needed from
> the 9 cells in row 3.  Now the next trick we need to apply our minds to
> is how via a loop we can change the row number in the Range parameter in
> the worksheet.Range('b3').value statement (i.e. 3 in the example you
> sent to me) to say 6 or any other specified value. So that I can extract
> the same 9 cells in row 6 that I did in row 3 and so on looping down to
> cover the rows that I need.  In other words do you think that we can use
> a varible like rowno in worksheet.Range('b+rowno').value instead of 3 or
> 6.
>
> --
> Posted via http://www.ruby-forum.com/.
>
>


-- 
Daniel Navarro
9035612340

--90e6ba6e8df64ced880494530da5--