[ANN] ruby-ole-1.2.3 released!

[Charles Lowe]

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

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.

 

[Junkone]

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

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.

can it open a excel file and save as csv.

 

[Charles Lowe]

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.

 

[bbiker]

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.

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.