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 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 > flexible approach, and still

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 wrote: > On Wed, Jan 19, 2011 at 1:40 PM, Ted Roche wrote: >> Or you could just throw the spreadsheet into Google Apps, since they >> seem to have worked out the multi-user document sharing aspects prett

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: > > > > http

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 wrote: > On Wed, Jan 19, 2011 at 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 p

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 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 us

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

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 Brian St. Pierre
On Wed, Jan 19, 2011 at 1:40 PM, Ted Roche 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 an API for Google Sp

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 > rel

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 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 is done from li

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 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 is painfu

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

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 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 interface to add en

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 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 actually running? :)

Re: Looking for a tool for spreadsheet manipulation.

2011-01-19 Thread 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 O

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 hav