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)?
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.
On Fri, Feb 13, 2009 at 4:48 PM, Mario G. [email protected]
wrote:
...or you can use the Spreadsheet gem: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.
http://spreadsheet.rubyforge.org
$> gem install spreadsheet
hth
Hannes
Hannes W. wrote:
On Fri, Feb 13, 2009 at 4:48 PM, Mario G. [email protected]
wrote:...or you can use the Spreadsheet gem: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.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!