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

Jim Deville jdeville at microsoft.com
Fri Jul 16 17:32:45 EDT 2010


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
http://hotgazpacho.org/


On Thu, Jul 15, 2010 at 8:10 PM, Eduardo Blumenfeld <lists at ruby-forum.com<mailto:lists at ruby-forum.com>> 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 Blumenfeld
--
Posted via http://www.ruby-forum.com/.
_______________________________________________
Ironruby-core mailing list
Ironruby-core at rubyforge.org<mailto:Ironruby-core at rubyforge.org>
http://rubyforge.org/mailman/listinfo/ironruby-core

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


More information about the Ironruby-core mailing list