[Ironruby-core] adding "each" support for a range brought from excel

Tomas Matousek Tomas.Matousek at microsoft.com
Fri Jul 16 20:28:26 EDT 2010

We don't support COM enumerators yet.


From: ironruby-core-bounces at rubyforge.org [mailto:ironruby-core-bounces at rubyforge.org] On Behalf Of Jim Deville
Sent: Friday, July 16, 2010 2:33 PM
To: ironruby-core at rubyforge.org
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 Green <will at hotgazpacho.org>
Sent: Friday, July 16, 2010 8:27 AM
To: ironruby-core at rubyforge.org <ironruby-core at rubyforge.org>
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 Green

On Thu, Jul 15, 2010 at 8:10 PM, Eduardo Blumenfeld <lists at ruby-forum.com<mailto:lists at ruby-forum.com>> wrote:

I'm trying to do the following:

load_assembly "Microsoft.Office.Interop.Excel"
include Microsoft::Office::Interop

app = Excel::ApplicationClass.new
worksheet =

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 Blumenfeld
Posted via http://www.ruby-forum.com/.
Ironruby-core mailing list
Ironruby-core at rubyforge.org<mailto:Ironruby-core at rubyforge.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://rubyforge.org/pipermail/ironruby-core/attachments/20100717/f81d0a75/attachment.html>

More information about the Ironruby-core mailing list