Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!feeder.news-service.com!feeds.phibee-telecom.net!talisker.lacave.net!lacave.net!not-for-mail From: Will James Newsgroups: comp.lang.ruby Subject: Re: Saving Electricty - Using a Blackboard? Date: Fri, 20 May 2011 13:19:23 -0500 Organization: Service de news de lacave.net Lines: 43 Message-ID: References: <267f0e6b73bdfa961dbda489c97c181d@ruby-forum.com> <7ee671500075e2f3292be2091ec54ac4@ruby-forum.com> <6d10d965e1a796d6b5755384175c3781@ruby-forum.com> NNTP-Posting-Host: bristol.highgroove.com Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Trace: talisker.lacave.net 1305915590 3093 65.111.164.187 (20 May 2011 18:19:50 GMT) X-Complaints-To: abuse@lacave.net NNTP-Posting-Date: Fri, 20 May 2011 18:19:50 +0000 (UTC) In-Reply-To: X-Received-From: This message has been automatically forwarded from the ruby-talk mailing list by a gateway at comp.lang.ruby. If it is SPAM, it did not originate at comp.lang.ruby. Please report the original sender, and not us. Thanks! For more details about this gateway, please visit: http://blog.grayproductions.net/categories/the_gateway X-Mail-Count: 383535 X-Ml-Name: ruby-talk X-Rubymirror: Yes X-Ruby-Talk: Xref: x330-a1.tempe.blueboxinc.net comp.lang.ruby:4830 Mike Stephens wrote in post #999926: > Will James wrote in post #999789: >>the above seems to require win32ole, for which, >> if I'm not mistaken, you need office to be installed on the system. > > I'm intrigued - how are you running Excel to get it to calculate > formulae if it's not on your computer? > > As it happens, I don't think win32ole has got anything to do with Office > anyway. It's to do with OLE, which is a Windows feature. Excel happens > to present an OLE object model. There are alternatives to office (i.e. openoffice) which allow you to work with excel spreadsheets but don't provide the necessary COM objects or whatever it is that's needed to use some features of certain libraries or modules in certain languages. I think to do: class ExcelConst end WIN32OLE.const_load(excel, ExcelConst) or excel = WIN32OLE::new('excel.Application') you do need to have excel installed. I remember in perl, to do stuff like: use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; you need to have excel on the system. I'm not a professional programmer (these days, I mostly program to automate a lot of painful data crunching tasks that would take ages to do by hand), so some of this is a bit beyond me... Chuck - thanks. It's too bad that the formula stuff isn't implemented yet, but could there be some clever workarounds to force or trick excel into evaluating? -- Posted via http://www.ruby-forum.com/.