From: gregarican <greg.kujawa@...>
Date: 2005-06-18T05:10:33+09:00
Subject: Ruby Excel question

I am looking to create a Ruby script that will extract an inventory
list from an SQL recordset. This recordset will be used for an offsite
e-commerce application. Usually I just pipe these recodsets to a CSV
text file. The trick is this particular script needs to also include
binary image files associated with each element of the SQL recordset
(i.e. - a JPG file for each SKU). So I am trying to port things over to
Excel as the output file since it can accept inserted binary images.

Looking at the Ruby Garden and some tips posted on the c.l.r board I
have a grasp on inserting text data into an Excel spreadsheet. What
would be the way to insert a JPG file into the spreadsheet using Ruby?
There are other ways around this, as I can just create a script to
upload the JPG files through FTP to get them where they need to be. But
I was looking to have all the data in one master document. Am I going
about this wrong?