Automating Excel with Ruby A Simple Example

Posted by Sam on Jun 09, 2009 at 12:00 AM UTC - 5 hrs From time to time I like to actually post a bit of code on this programming blog, so here's a stream-of-conscious (as in "not a lot of thought went into design quality") example that shows how to: Open Excel, making it invisible (or visible) to the user. Create a workbook and access individual worksheets Add data to a cell, or retrieve data fro