[Gretl-users] exporting to excel

[Chris]

One other thing, I don't see a readily obvious way to run gretl in batch
like mode. To get this to work I need to be able to do something like call
gretl, feed it the regression request, point it to the data and have the
data saved as a csv file somewhere all without user interaction. Did I miss
that this is not possible in the manual?

Thanks,

Chris


On 5/11/07, Chris <quilley at gmail.com> wrote:
>
> Thanks,
>
> I'll look into it, but I think it will be easier to just write the script
> to pull data from the csv and plop it onto a sheet in the excel spread
> sheet.
>
> Thanks,
>
> Chris
>
> On 5/11/07, Riccardo (Jack) Lucchetti <r.lucchetti at univpm.it> wrote:
> >
> > On Fri, 11 May 2007, Chris wrote:
> >
> > > That's fine, I suppose it's just a couple more lines of VBA to import
> > the
> > > csv file;)
> > >
> > > Thanks,
> > >
> > > Chris
> > >
> > > On 5/11/07, Allin Cottrell < cottrell at wfu.edu> wrote:
> > >>
> > >> On Fri, 11 May 2007, Chris wrote:
> > >>
> > >> > Is it possible to get gretl to put output into an excel
> > spreadsheet?
> > >>
> > >> Not unless somebody else wants to write an exporter.  Gretl can
> > >> output CSV just fine, but doesn't export to closed binary formats.
> >
> > You may be already aware of this, but gnumeric (also available for Win32
> >
> > if you need it) provides a command-line tool called ssconvert that will
> > take a csv file produced by gretl and turn it into a perfectly legit xls
> > file.
> >
> > You may either write a script that calls ssconvert, call ssconvert from
> > within gretl via "!" or, better still, rip the C code from gnumeric and
> > incorporate it into gretl if you really need this functionality badly.
> >
> >
> > Riccardo (Jack) Lucchetti
> > Dipartimento di Economia
> > Università Politecnica delle Marche
> >
> > r.lucchetti at univpm.it
> > http://www.econ.univpm.it/lucchetti
> > _______________________________________________
> > Gretl-users mailing list
> > Gretl-users at lists.wfu.edu
> > http://lists.wfu.edu/mailman/listinfo/gretl-users
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wfu.edu/pipermail/gretl-users/attachments/20070512/22136ec4/attachment.htm