[Gambas-user] output to open office files

[Robert JUHASZ]

Hello,

Thanks for both of you for the answers!
The solution you described Benoît is very sympa for me. Could you give me
your 'dirty' code in a module in order to add to my project and use your
function to write cells?
I may also learn from your code.

(My standard way for the output is to use templete files so I don't need to
bother with the formatting, printing issues or whatever: I just modify some
cells with the actual data and I leave the file open for the user. My
colleages are already got used with this method and would be very good to
keep this habit under linux in my Gambas applications).

Regards,
Robi

2010/1/20 Benoît Minisini <gambas at ...1...>

> > 2010/1/20 yuhej <robert1juhasz at ...626...>:
> > > Hello Benoît,
> > >
> > > As far as I know we have no easy option to write data to open office
> calc
> > > files like VB can do to excel.
> > > Once I read in a comment of you - if my memory is correct - that you
> plan
> > > to do a function for that but only in the far future. Is it previewed
> in
> > > Gambas2 or do you have any schedule on that? It would be very useful.
> >
> > Hey, far be it from me to stick my nose in where isn't appreciated,
> > but on this occasion I'll allow myself an indulgence.
> >
> > If you want "to write data to open office calc files like VB can do to
> > excel", the Open Office source code is here:
> >
> > http://download.openoffice.org/2.1.0/source.html
> >
> > My response is excused by virtue of me being told almost exactly the
> > same thing by [censored].
> >
> > HTH
> >
>
> More concretely, open office files are XML text files, so you don't really
> need a binary interface on a black box as Microsoft did with Office.
>
> Just uncompress the openoffice file with "unzip", modify the xml files
> inside,
> and compress it back.
>
> Of course you must know the OpenOffice format, which is a documented
> standard.
> But if you have saved your openoffice files with no optimization, the
> generated xml files can be read and understood with any text editor.
>
> Otherwise, I have started to develop an API to access OpenOffice calc files
> for myself, but it is to quick & dirty to be released. You just tell what
> you
> want to put in which cell, and all the dirty work is done in the background
> (uncompressing the openoffice file, inserting columns and lines when needed
> inside the content.xml file, compress it back...)
>
> Regards,
>
> --
> Benoît Minisini
>
>
> ------------------------------------------------------------------------------
> Throughout its 18-year history, RSA Conference consistently attracts the
> world's best and brightest in the field, creating opportunities for
> Conference
> attendees to learn about information security's most important issues
> through
> interactions with peers, luminaries and emerging and established companies.
> http://p.sf.net/sfu/rsaconf-dev2dev
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>