[Gretl-users] exporting to excel

[Riccardo (Jack) Lucchetti]

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