Adding "each" support for a range brought from excel

Ruby IronRuby
1

Hi,

I’m trying to do the following:

load_assembly “Microsoft.Office.Interop.Excel”
include Microsoft::office::Interop

app = Excel::ApplicationClass.new
worksheet =
app.workbooks.open(“samename.xlsx”.to_clr_string).worksheets[1]

range = worksheet.range(“A1:Z1”.to_clr_string)

at this point I can:

puts range[1].value # works

but I can’t do
range.each {|r| …}

is there any way of defining, extending the class to accept each (and
size for the matter) as methods?

Thank you very much

Eduardo B.

2

You can re-open the class that defines a Worksheet Range and include
Ruby’s
Enumerable as a mixin

–
Will G.
http://hotgazpacho.org/

3

This also seems like something that should ‘just work’… Tomas, any
idea why it doesn’t

From: Will G. [email protected]
Sent: Friday, July 16, 2010 8:27 AM
To: [email protected] [email protected]
Subject: Re: [Ironruby-core] adding “each” support for a range brought
from excel

You can re-open the class that defines a Worksheet Range and include
Ruby’s Enumerable as a mixin

–
Will G.
http://hotgazpacho.org/

On Thu, Jul 15, 2010 at 8:10 PM, Eduardo B.
<[email protected]mailto:[email protected]> wrote:
Hi,

I’m trying to do the following:

load_assembly “Microsoft.Office.Interop.Excel”
include Microsoft::office::Interop

app = Excel::ApplicationClass.new
worksheet =
app.workbooks.open(“samename.xlsx”.to_clr_string).worksheets[1]

range = worksheet.range(“A1:Z1”.to_clr_string)

at this point I can:

puts range[1].value # works

but I can’t do
range.each {|r| …}

is there any way of defining, extending the class to accept each (and
size for the matter) as methods?

Thank you very much

Eduardo B.

Posted via http://www.ruby-forum.com/.

4

We don’t support COM enumerators yet.

Tomas

From: [email protected]
[mailto:[email protected]] On Behalf Of Jim D.
Sent: Friday, July 16, 2010 2:33 PM
To: [email protected]
Subject: Re: [Ironruby-core] adding “each” support for a range brought
from excel

This also seems like something that should ‘just work’… Tomas, any
idea why it doesn’t

From: Will G. [email protected]
Sent: Friday, July 16, 2010 8:27 AM
To: [email protected] [email protected]
Subject: Re: [Ironruby-core] adding “each” support for a range brought
from excel
You can re-open the class that defines a Worksheet Range and include
Ruby’s Enumerable as a mixin

–
Will G.
http://hotgazpacho.org/

On Thu, Jul 15, 2010 at 8:10 PM, Eduardo B.
<[email protected]mailto:[email protected]> wrote:
Hi,

I’m trying to do the following:

load_assembly “Microsoft.Office.Interop.Excel”
include Microsoft::office::Interop

app = Excel::ApplicationClass.new
worksheet =
app.workbooks.open(“samename.xlsx”.to_clr_string).worksheets[1]

range = worksheet.range(“A1:Z1”.to_clr_string)

at this point I can:

puts range[1].value # works

but I can’t do
range.each {|r| …}

is there any way of defining, extending the class to accept each (and
size for the matter) as methods?

Thank you very much

Eduardo B.

Posted via http://www.ruby-forum.com/.