Looking for a tool for spreadsheet manipulation.

[Peter Dobratz]

I've used pyExcelerator to create and manipulate excel files:

http://sourceforge.net/projects/pyexcelerator/

It's a Python library, so it's not exactly what you are describing,
but perhaps it can serve your purpose.  It has support for a lot of
Excel's internal cell formatting and such.

Peter

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:
>
> 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
> _______________________________________________
> gnhlug-discuss mailing list
> gnhlug-discuss at mail.gnhlug.org
> http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss/
>