I had an exchange on the Ruby-Gnome list and although the general opinion is that GOffice-Introspection is available, dependencies to Goffice and Gsf are not (yet) honored. If I have understood everything, there is currently no way to manipulate Gnumeric with Ruby in this way.
But the interest of some smart people in the topic gives me hope. (Hope
quoi. C'est IT, yeah).
On Sun, Nov 01, 2015 at 08:41:18PM +0100, Jean Bréfort wrote:
> I don't know for Ruby, but with Python, you can do something like:
>
> $ python
> >>> import gi
> >>> gi.require_version('GOffice','0.10')
> >>> from gi.repository import GOffice
> >>> gi.require_version('Gnm', '1.12')
> >>> from gi.repository import Gnm
> >>> Gnm.init()
> >>> wb=Gnm.Workbook.new_with_sheets(1)
> >>> sheet=wb.sheet_by_index(0)
> >>> cell=sheet.cell_create(0,0)
> >>> cell.set_text('Hello World!')
> >>> cc=Gnm.CmdContextStderr.new()
> >>> uri='file:///home/jean/MyWb.gnumeric'
> >>> fs=GOffice.FileSaver.for_file_name(uri)
> >>> wv=Gnm.WorkbookView.new(wb)
> >>> Gnm.wb_view_save_as(wv,fs,uri,cc)
>
> Due to poor naming conventions in gnumeric, the last line is not
> wv.save_as(fs,uri,cc)
>
> That will have to be enhanced in next version.
>
> Hope this helps,
>
> Jean
>
> Le dimanche 01 novembre 2015 à 15:03 +0100, Michael Uplawski a écrit :
> > It's me again. Now on GObject
> >
> > On Fri, Oct 30, 2015 at 03:10:15PM +0100, Jean Brefort wrote:
> > > Note that gnumeric scripting is available through gobject-
> > > introspection
> > > for many languages such as javascript, python (2.7 only for now),
> > > and
> > > others. I suppose ruby is part of the list.
> > > I think that we have most of which would be needed to implement
> > > macros
> > > (using the same languages).
> >
> > The information which is available on the Web does not help to enter
> > this new world, let alone to find your way. I am even unsure what
> > they
> > are dealing on those pages and in those documents. If they explain
> > how
> > language bindings are created by use of GObject-Inspection, thank
> > you. I
> > am not interested.
> >
> > Let's forget all that. Where or how can I obtain a list of objects,
> > that
> > I can address in code, while a Gnumeric session is running, and in an
> > effort to manipulate ... “things” (let's say cell-values and the
> > like)
> > *in that very running Gnumeric-Session*. Jean called that macros, but
> > I
> > am not sure that everybody has the same understanding of macros.
> >
> > I can require the Ruby-module or the Ruby-modules which are provided
> > for
> > GObject-Inspection. What I lack is any knowledge of how I get in
> > touch
> > with Gnumeric. If this is too basic and needs too much words to
> > explain,
> > say so, too. It would just confirm my initial impression and make me
> > hope for a working Python-Plugin in the future.
> >
> > Thanks for all you do, anyway.
> >
> > Michael
> >
> >
> >
> > >
> > > Le vendredi 30 octobre 2015 à 13:35 +0100, Michael Uplawski a
> > > écrit :
> > > > Good afternoon.
> > > >
> > > > On Fri, Oct 30, 2015 at 09:59:30AM +0100, Jean Brefort wrote:
> > > > > I suppose you need python-dev. Note that gnumeric does not
> > > > > support
> > > > > Python-3 for now.
> > > >
> > > > And that would be it. After some attempts to provide needed
> > > > dependencies, a simply missing Python-3 support is the best hint
> > > > of
> > > > all,
> > > > for now.
> > > >
> > > > I may opt for a parallel installation of two Gnumeric versions.
> > > > More background: I am a fierce adept of the SoftMaker Office-
> > > > Suite
> > > > (non-free, commercial, closed source and all.., but some
> > > > attributes
> > > > that
> > > > you have to experience, see, hear and do yourself to understand).
> > > >
> > > > Automation/scripting is available only in their Windows-release
> > > > and
> > > > only
> > > > by means of OLE and yet another Basic-variant. Gnumeric has other
> > > > advantages, too; that is why I am completely “undecided” as to
> > > > which
> > > > program to use.
> > > >
> > > > If Python worked or if any other scripting-language (I mean Ruby)
> > > > could
> > > > be used to automate any spreadsheets that are *not* Excel, all
> > > > were
> > > > clear. For the time, neither the spreadsheet-programs nor the
> > > > scripting
> > > > interfaces provided for different languages satisfy me.
> > > >
> > > > Just go ahead with the plugin-interface and it will be great. ;-)
> > > >
> > > > TIA,
> > > >
> > > > Michael
> > > >
> >
> > _______________________________________________
> > gnumeric-list mailing list
> > gnumeric-list@gnome.org
> > https://mail.gnome.org/mailman/listinfo/gnumeric-list
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list@gnome.org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
--
ATTN! New Key!
GnuPG brainpoolP512r1/5C2A258D 2015-10-02 [expires: 2017-10-01]
Michael Uplawski <michael.uplaw...@uplawski.eu>
fingerprint: 2A44 09D4 54B4 EBD2 90DA 0B2D E8B8 0614 5C2A 258D
sub brainpoolP512r1/53461AFA 2015-10-02 [expires: 2017-10-01]
signature.asc
Description: PGP signature
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
