Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Steven W. Orr
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

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Benjamin Scott
On Wed, Jan 19, 2011 at 11:06 AM, Steven W. Orr ste...@syslang.net wrote: 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? You mention Excel but this is a Linux list. What OS and application are you

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Brian St. Pierre
On Wed, Jan 19, 2011 at 11:06 AM, Steven W. Orr ste...@syslang.net wrote: 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

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Steven W. Orr
On 1/19/2011 11:06 AM, Steven W. Orr 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

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Tom Buskey
On Wed, Jan 19, 2011 at 12:17 PM, Steven W. Orr ste...@syslang.net wrote: On 1/19/2011 11:06 AM, Steven W. Orr 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

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Brian St. Pierre
On Wed, Jan 19, 2011 at 12:17 PM, Steven W. Orr ste...@syslang.net wrote: Right now, everyone is using Excel from windows to add their entries. I don't actually know if using anything else (OOO, gnumeric, etc,) would cause unintended ripples to the files. All the devel work that I deal with

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Ted Roche
On 01/19/2011 12:17 PM, Steven W. Orr wrote: I'm getting some good feedback, including letting me know what info I did not provide. The deal is that we are releasing software whose src code is properly tagged (or labeled). There are*lots* of labels. The binaries are constructed and released

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Brian St. Pierre
On Wed, Jan 19, 2011 at 1:40 PM, Ted Roche tedro...@tedroche.com wrote: Or you could just throw the spreadsheet into Google Apps, since they seem to have worked out the multi-user document sharing aspects pretty well. However, I don't know of a command-line interface to that! Google provides

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread David Berube
On 01/19/2011 01:51 PM, Brian St. Pierre wrote: Google provides an API for Google Spreadsheets: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html and a python client library: http://code.google.com/p/gdata-python-client/ -Brian

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Joel Burtram
If you want to stay invisible and you're willing to run from the windows command line, see http://code.activestate.com/recipes/573471-update-stock-quote-using-yahoo-finance-web-service/ for an example of manipulating Excel spreadsheets using python and win32com. Your file sounds like a

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Thomas Charron
On Wed, Jan 19, 2011 at 11:06 AM, Steven W. Orr ste...@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

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Thomas Charron
On Wed, Jan 19, 2011 at 4:00 PM, Thomas Charron twaf...@gmail.com wrote: On Wed, Jan 19, 2011 at 11:06 AM, Steven W. Orr ste...@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

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Andy Bair
On Wed, Jan 19, 2011 at 02:13:58PM -0500, David Berube wrote: On 01/19/2011 01:51 PM, Brian St. Pierre wrote: Google provides an API for Google Spreadsheets: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html and a python client library:

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Seth Cohn
Seconded, this would be my answer as well. On Wed, Jan 19, 2011 at 1:51 PM, Brian St. Pierre br...@bstpierre.org wrote: On Wed, Jan 19, 2011 at 1:40 PM, Ted Roche tedro...@tedroche.com wrote: Or you could just throw the spreadsheet into Google Apps, since they seem to have worked out the

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread Thomas Charron
On Wed, Jan 19, 2011 at 2:13 PM, David Berube djber...@berubeconsulting.com wrote: Alternatively, instead of editing the document, you could edit a CSV text file, tab delimited text file, or database table and then generate your XLS/google doc document from that - which is likely your most