From: Geeta Sachdeva <manchanda.geeta@...>
Date: 2007-10-16T14:18:24+09:00
Subject: Re: Excel Parsing : extract values of cells with formulae

Bernard Kenik wrote:
> On Oct 15, 9:04 am, Geeta Sachdeva <manchanda.ge...@gmail.com> wrote:
>>
>> Thanks,
>> Geeta
>> --
>> Posted viahttp://www.ruby-forum.com/.
> 
> If you are on Windows then I suggest that you use win32ole to
> manipulate Excel workbooks and worksheets.
> I am fairly proficient in using Ruby and WIN32OLE and if you need some
> assistance you can contact me offline.
> 
> You might want to look at the 'roo' gem if you only want to extract
> values from an Microsoft Excel sheet or Open Office Calc document.

Hi Bernard,

Thanks for the response.
OS ill be using this parser on is Mac and not Windows.

Does 'roo' gem also evaluate formulas? Because as I mentioned earlier, I 
also need values of cells which have formulae, aslo some of the cells In 
the excel refer to different excel files or different sheets in same 
file.

Thanks,
Geeta
-- 
Posted via http://www.ruby-forum.com/.