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