Must MS-Excel be installed on the machine to ONLY read an MS


#1

Must MS-Excel be installed on the machine to ONLY read an MS-Excel
worksheet file (e.g. TEST.XLS) with Ruby (using Ruby’s win32ole
library)?


#2

Daniel Summars wrote:

Must MS-Excel be installed on the machine to ONLY read an MS-Excel
worksheet file (e.g. TEST.XLS) with Ruby (using Ruby’s win32ole
library)?

Yes. Win32OLE works with the host app, in this case Excel. You probably
want a COM library that can read/write excel spreadsheets directly. I
think there are free ones out there but it depends on what features and
excel version support you need.


#3

On Fri, Feb 13, 2009 at 4:48 PM, Mario G. removed_email_address@domain.invalid
wrote:

Daniel Summars wrote:

Must MS-Excel be installed on the machine to ONLY read an MS-Excel
worksheet file (e.g. TEST.XLS) with Ruby (using Ruby’s win32ole
library)?

Yes. Win32OLE works with the host app, in this case Excel. You probably
want a COM library that can read/write excel spreadsheets directly. I
think there are free ones out there but it depends on what features and
excel version support you need.

...or you can use the Spreadsheet gem:

http://spreadsheet.rubyforge.org

$> gem install spreadsheet

hth
Hannes


#4

Hannes W. wrote:

On Fri, Feb 13, 2009 at 4:48 PM, Mario G. removed_email_address@domain.invalid
wrote:

Daniel Summars wrote:

Must MS-Excel be installed on the machine to ONLY read an MS-Excel
worksheet file (e.g. TEST.XLS) with Ruby (using Ruby’s win32ole
library)?

Yes. Win32OLE works with the host app, in this case Excel. You probably
want a COM library that can read/write excel spreadsheets directly. I
think there are free ones out there but it depends on what features and
excel version support you need.

...or you can use the Spreadsheet gem:

http://spreadsheet.rubyforge.org

$> gem install spreadsheet

hth
Hannes

Hannes W. and Mario Gutierre,

Thank you both.
Both answers are very helpful.
I’m also thinking it would make a lot of sense too if the provider of
the spreadsheets simply saved them to CSV files too. Then we probably
really don’t need MS-Excel at all.

Thanks again!