7:08 a.m.
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..
/Antonello
--
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(a)univpm.it
OpenDocument formats welcome.
12:15 p.m.
On Fri, 1 Sep 2006, 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..
You're right, that's not possible at present -- but it's on the
"to do" list.
Allin Cottrell
12:26 p.m.
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
Riccardo "Jack" Lucchetti
Dipartimento di Economia
Facoltà di Economia "G. Fuà"
Ancona
1:14 p.m.
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
--
GPG/PGP Key-Id 0x943A5F0E - http://www.linux.it/~cri/cri.asc
Free software, free society - http://www.fsfeurope.org
6:28 a.m.
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(a)univpm.it
OpenDocument formats welcome.
5:03 p.m.
On Fri, 1 Sep 2006, 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.
Would it be worth adding the ability to import from XLS in a
simple "no-options" mode? That is, we alwats import from the
first sheet in the workbook, and we always start the import at
cell A1? That would not be too difficult.
Allin.
6997
days inactive
7000
days old
5 comments
4 participants
participants (4)
-
Allin Cottrell -
Antonello Lobianco -
Cristian Rigamonti -
Riccardo Jack Lucchetti