[Gretl-users] Importing excel sheets for batch jobs..

[Antonello Lobianco]

Il giorno ven, 01/09/2006 alle 15.14 +0200, Cristian Rigamonti ha
scritto:

> On Fri, Sep 01, 2006 at 02:26:56PM +0200, Riccardo Jack Lucchetti  wrote:
> > 
> > On Fri, September 1, 2006 09:08, Antonello Lobianco wrote:
> > > Hello.. while in the GUI it is possible to import Excel documents (and
> > > it would be nice also openoffice), I can't see a way to do that using
> > > the terminal..
> > 

> > Not trivial, as Excel files can have more than 1 folder. In case there's only
> > one, a possible workaround is to use ssconvert, gnumeric's command-line
> > utility for converting formats. Example:
> > 
> > ssconvert foo.xls foo.csv && gretlcli foo.csv
> 
> Two other useful command-line tools to convert xls files into ascii and csv:
> 
> - xlhtml: http://chicago.sourceforge.net/xlhtml/
> 
> - xls2csv: a tool from the catdoc package:
>   http://www.45.free.net/~vitus/software/catdoc/
> 
> (Debian packages: xlhtml and catdoc)
> 
> Cri


Converting from excel to csv is not a problem, other ways e.g. are
opening it with openoffice or using excel under wine.. the fact is that
I didn't want mess with different files, if I HAVE to use excel and
share them with others..




-- 
Antonello Lobianco
PhD student in Agricultural Policies
Department of Economics, Polytechnic University of Marche
P.le Martelli 8, 60121 Ancona (Italy)
Tel: +39.071.2207106 / Fax: +39.071.2207102
a.lobianco at univpm.it
OpenDocument formats welcome.