Looking for a tool for spreadsheet manipulation.

[Thomas Charron]

On Wed, Jan 19, 2011 at 4:00 PM, Thomas Charron <twaffle at gmail.com> wrote:
> On Wed, Jan 19, 2011 at 11:06 AM, Steven W. Orr <steveo at syslang.net> wrote:
>> Sometimes I get lucky here. ;-)
>>
>> I have this horrible spreadsheet that needs to be accessed by lots of people
>> from all over the galaxy. Adding entries to the spreadsheet is painful because
>> it's manual.
>>
>> What I'd like to do is to use a command line interface to add entries to cells
>> instead of having to use Excel. Does such a beast exist?
>>
>> I'm thinking of some sort of a command that either takes command args or a
>> configuration file to accomplish what I want. For example:
>
>  Doing it with Perl on a Windows system is *superduper* cake.

  I'm in a meeting, but a quick example search of the OLE interfaces I
came across:

http://www.ngbdigital.com/perl_ole_excel.html

  This is exactly how I've been using it when automating some robotics
tests where the 'test log' was stored in an Excel spreadsheet.

-- 
-- Thomas