[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

[ANN] ruby-ole-1.2.3 released!

Charles L.

12/28/2007 12:16:00 PM

The new version of ruby-ole has been released!

ruby-ole is a library for read/write access to OLE2 structured storage
files, such as those produced by Microsoft Office, eg *.doc, *.msg etc.
It provides a simple filesystem style api.

Details at http://code.google.com/p....

Changes:

- MBAT write support re-implmented (for saving large OLE files).
- Minor fixes and better test coverage.
- Initial (read-only) property set support.
- Optimizations from benchmarks and profiling, mostly for writes.
--
Posted via http://www.ruby-....
3 Answers

Junkone

12/28/2007 4:10:00 PM

0

On Dec 28, 7:16 am, Charles Lowe <aquas...@gmail.com> wrote:
> The new version of ruby-ole has been released!
>
> ruby-ole is a library for read/write access to OLE2 structured storage
> files, such as those produced by Microsoft Office, eg *.doc, *.msg etc.
> It provides a simple filesystem style api.
>
> Details athttp://code.google.com/p....
>
> Changes:
>
> - MBAT write support re-implmented (for saving large OLE files).
> - Minor fixes and better test coverage.
> - Initial (read-only) property set support.
> - Optimizations from benchmarks and profiling, mostly for writes.
> --
> Posted viahttp://www.ruby-....

can it open a excel file and save as csv.

Charles L.

12/29/2007 7:00:00 AM

0

Junkone wrote:
> On Dec 28, 7:16�am, Charles Lowe <aquas...@gmail.com> wrote:
>> - MBAT write support re-implmented (for saving large OLE files).
>> - Minor fixes and better test coverage.
>> - Initial (read-only) property set support.
>> - Optimizations from benchmarks and profiling, mostly for writes.
>> --
>> Posted viahttp://www.ruby-....
>
> can it open a excel file and save as csv.

No, its just an implementation of the underlying file format - just a
container like a zip file (though without compression). See the
parseexcel library for that purpose.
--
Posted via http://www.ruby-....

Bernard Kenik

12/30/2007 1:52:00 AM

0

On Dec 29, 2:00 am, Charles Lowe <aquas...@gmail.com> wrote:
> Junkone wrote:
> > On Dec 28, 7:16?am, Charles Lowe <aquas...@gmail.com> wrote:
> >> - MBAT write support re-implmented (for saving large OLE files).
> >> - Minor fixes and better test coverage.
> >> - Initial (read-only) property set support.
> >> - Optimizations from benchmarks and profiling, mostly for writes.
> >> --
> >> Posted viahttp://www.ruby-....
>
> > can it open a excel file and save as csv.
>
> No, its just an implementation of the underlying file format - just a
> container like a zip file (though without compression). See the
> parseexcel library for that purpose.
> --
> Posted viahttp://www.ruby-....

If I understand your situation correctly: you do not have Microsoft
Excel and you want to use WIN32OLE to open the Excel file. No, you
cannot do that. WIN32OLE effectively turns Excel into a server. This
way you can control Excel and have it do what you want.

If you have OpenOffice.org suite then you can open the excel file (not
Excel 2007) and save the file as a csv file. A gem is currently being
worked by Nathan Hale that can interface with OpenOffice.org, this gem
works only on Windows since it use WIN32OLEs to communicate with
OpenOffice.org via UNO COM interface.

PS OpenOffice.org is free and can replace Microsoft Office for most
purposes. OpenOffice.org works on Windows, MacOS, and Linus/Unix.

Hope that helps.