Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.ruby > #4830

Re: Saving Electricty - Using a Blackboard?

Show all headers | View raw

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/.

Back to comp.lang.ruby | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Writing formulas to excel spreadsheet Will James <ampclj9@hotmail.com> - 2011-05-19 11:22 -0500
  Re: Writing formulas to excel spreadsheet Mike Stephens <rubfor@recitel.net> - 2011-05-19 16:58 -0500
    Re: Writing formulas to excel spreadsheet 7stud -- <bbxx789_05ss@yahoo.com> - 2011-05-19 17:37 -0500
      Re: Writing formulas to excel spreadsheet Will James <ampclj9@hotmail.com> - 2011-05-19 23:42 -0500
        Re: Writing formulas to excel spreadsheet Chuck Remes <cremes.devlist@mac.com> - 2011-05-20 09:28 -0500
        Saving Electricty - Using a Blackboard? Mike Stephens <rubfor@recitel.net> - 2011-05-20 12:41 -0500
          Re: Saving Electricty - Using a Blackboard? Will James <ampclj9@hotmail.com> - 2011-05-20 13:19 -0500
  Matz never said Microsoft was the Devil Incarnate. (or did he?) Mike Stephens <rubfor@recitel.net> - 2011-05-20 16:36 -0500
    Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Daniel Berger <djberg96@gmail.com> - 2011-05-20 17:02 -0500
      Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Will James <ampclj9@hotmail.com> - 2011-05-20 21:28 -0500
        Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Mike Stephens <rubfor@recitel.net> - 2011-05-21 16:14 -0500
          Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Damjan Rems <d_rems@yahoo.com> - 2011-05-23 15:18 -0500
            Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Will James <ampclj9@hotmail.com> - 2011-05-24 11:45 -0500
          Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Mike Stephens <rubfor@recitel.net> - 2011-05-23 16:38 -0500
            Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Michal Suchanek <hramrach@centrum.cz> - 2011-05-23 18:00 -0500
              Keep your options open Mike Stephens <rubfor@recitel.net> - 2011-05-24 12:45 -0500
                Re: Keep your options open Johnny Morrice <spoon@killersmurf.com> - 2011-05-24 13:22 -0500
                Re: Keep your options open Stu <stu@rubyprogrammer.net> - 2011-05-24 16:55 -0500
            Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Christopher Dicely <cmdicely@gmail.com> - 2011-05-23 20:53 -0500
        Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Colin Bartlett <colinb2r@googlemail.com> - 2011-05-25 10:27 -0500
          Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Mike Stephens <rubfor@recitel.net> - 2011-05-25 11:54 -0500
          Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Will James <ampclj9@hotmail.com> - 2011-05-25 13:53 -0500
            Re: Matz never said Microsoft was the Devil Incarnate. (or did he?) Will James <ampclj9@hotmail.com> - 2011-05-26 12:46 -0500

csiph-web