Looking for a tool for spreadsheet manipulation.

Steven W. Orr steveo at syslang.net
Wed Jan 19 11:06:58 EST 2011


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:

I have a cell that says "FooBar", and I want to add stuff to the next two 
cells to the right of it. For example, an awk-like syntax to accomplish this 
might look like:

cmd '/Foobar/ {set(row, col+1, abc); set(row, col+2, 123)}' fn.xls

What I really want to do is somewhat more involved, but this is a great jump 
point to get me started. Anyone have any ideas?

TIA

-- 
Time flies like the wind. Fruit flies like a banana. Stranger things have  .0.
happened but none stranger than this. Does your driver's license say Organ ..0
Donor?Black holes are where God divided by zero. Listen to me! We are all- 000
individuals! What if this weren't a hypothetical question?
steveo at syslang.net


More information about the gnhlug-discuss mailing list