Re: Controlling gnumeric from Python

[John Gill <jng earthenware-services org>]

Thanks for the ssconvert to csv idea --  i've got several places where I can put that to very good use.

I have been wanting for some time to write some python code to parse the gnumeric xml format + have it create a pworkbook  -- http://www.earthenware-services.org/earthenwarewiki/PworkBook -- object to represent the gnumeric file.   I'd have quite a few uses for that + I suspect it isn't very much work to get something basic up and running.

Longer term, I think the way to go is to have some python bindings to Jody's libgnumeric.

John

Shahms King wrote:

Any particular reason you need to use Gnumeric from Python?  Assuming
the data you want is basic tabular data you can easily use ssconvert to
output a comma or tab delimited file and read that into Python using the
csvlib module...

On Wed, 2005-01-05 at 12:18 -0800, Alexey Goldin wrote:
  

Ok, this is a trick question, I guess.  I am trying to use gnumeric to
read Excel file (no, Basic macros, gnumeric reads it Ok) and get data
into Python. For some reason I was sure this is trivial to do.
However, after spending the whole day googling and looking through
documentation I found only one 5 year old example using old naming
scheme with GOADID and a note that in neares future interface is
likely to change.

I'd like to do something like this:

import bonobo
bonobo.activate()
obj = bonobo.get_object("OAFIID:GNOME:Gnumeric:WorkbookFactory:1.0",
"What do I write here?")
v=obj.get_cel_value(....)

So, is anyone using gnumeric in such a way? Is it possible?  If not,
why not? Is there a modern example?

Probably grokking all the CORBA and Bonobo documentation is a good
idea but, alas, it would take many months :-)

Thanks!
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

    

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list