Ruby plugin for spreadsheet?

ruby-talk
1

I know this may sound insane... but is there anything like a ruby plugin
for spreadsheets? Sadly, I guess I'd prefer Excel, but I use OpenOffice
alot too. basically, there is always text manipulation of fields I need to
do. Its a royal pain in most spreadsheet software. I usually end up
exporting my data out to a csv, running some Ruby scripts on it, and then
importing it back. Trying to reduce the work here. Since... exporting it
out, running ruby scripts on it, then importing it back in is still easier
for me.

2

http://raa.ruby-lang.org/project/parseexcel/

Alternatively consider Win32OLE. The upside to ParseExcel is that you don't need Excel to use it.

···

On Feb 23, 2006, at 8:13 PM, Grant Schoep wrote:

I know this may sound insane... but is there anything like a ruby plugin
for spreadsheets? Sadly, I guess I'd prefer Excel, but I use OpenOffice
alot too. basically, there is always text manipulation of fields I need to
do. Its a royal pain in most spreadsheet software. I usually end up
exporting my data out to a csv, running some Ruby scripts on it, and then
importing it back. Trying to reduce the work here. Since... exporting it
out, running ruby scripts on it, then importing it back in is still easier
for me.

3

I actually did a project a couple of years ago which used the Win32 OLE
library for Ruby -- check out the ActiveScriptRuby distribution
(http://arton.hp.infoseek.co.jp/).

Instead of doing a Ruby "plugin" for Excel, I used Ruby to automate
Excel operations: open a workbook, select a worksheet, create a new
sheet, copy some data into it, etc.

-Lennon

4

Check this thread out >> http://groups.google.com/group/comp.lang.ruby/browse_thread/thread/15326c311fafc888/8ae49e950ee8c49d?q=Excel+spreadsheet&rnum=2#8ae49e950ee8c49d

It

might be of use.

James

···

On 2006-02-23 20:10:06 -0500, Grant Schoep <matobinder@idcomm.abcremooveabc.com> said:

I know this may sound insane... but is there anything like a ruby plugin for spreadsheets? Sadly, I guess I'd prefer Excel, but I use OpenOffice alot too. basically, there is always text manipulation of fields I need to do. Its a royal pain in most spreadsheet software. I usually end up exporting my data out to a csv, running some Ruby scripts on it, and then importing it back. Trying to reduce the work here. Since... exporting it out, running ruby scripts on it, then importing it back in is still easier for me.