From edd at debian.org  Mon Jan 17 23:04:21 2005
From: edd at debian.org (Dirk Eddelbuettel)
Date: Mon Jan 17 23:04:28 2005
Subject: [Rd] Excel files-suggested manual addition
In-Reply-To: <Pine.LNX.4.61.0501172151360.9155@gannet.stats>
References: <1105997042.4379.212944892@webmail.messagingengine.com>
	<Pine.LNX.4.61.0501172151360.9155@gannet.stats>
Message-ID: <20050117220421.GA1302@sonny.eddelbuettel.com>

On Mon, Jan 17, 2005 at 09:53:38PM +0000, Prof Brian Ripley wrote:
> What does it convert them to that is useful for R import?

On Debian testing with Gnumeric 1.4.1, ssconvert says

edd@basebud:~> ssconvert --list-exporters
ID                            Description
Gnumeric_OpenCalc:openoffice | OpenOffice OASIS _UNFINISHED_
Gnumeric_Excel:excel_dsf     | MS Excel (tm) 97/2000/XP & 5.0/95
Gnumeric_Excel:excel_biff8   | MS Excel (tm) 97/2000/XP
Gnumeric_Excel:excel_biff7   | MS Excel (tm) 5.0/95
Gnumeric_xml_sax:xml_sax     | Gnumeric XML (*.gnumeric)
Gnumeric_html:roff           | TROFF (*.me)
Gnumeric_html:latex          | LaTeX 2e (*.tex)
Gnumeric_html:xhtml_range    | XHTML range - for export to clipboard
Gnumeric_html:xhtml          | XHTML (*.html)
Gnumeric_html:html40frag     | HTML (*.html) fragment
Gnumeric_html:html40         | HTML 4.0 (*.html)
Gnumeric_html:html32         | HTML 3.2 (*.html)
Gnumeric_dif:dif             | Data Interchange Format (*.dif)
Gnumeric_stf:stf_csv         | Comma separated values (CSV)
Gnumeric_stf:stf_assistant   | Text export (configurable)
Gnumeric_XmlIO:gnum_xml      | Gnumeric XML (*.gnumeric) original slow
exporter
edd@basebud:~> ssconvert --list-importers
ID                            Description
Gnumeric_html:html           | HTML (*.html, *.htm)
Gnumeric_oleo:oleo           | GNU Oleo (*.oleo)
Gnumeric_QPro:qpro           | Quatro Pro (*.wb1, *.wb2, *.wb3)
Gnumeric_Excel:excel         | MS Excel (tm) (*.xls)
Gnumeric_xbase:xbase         | Xbase (*.dbf) file format
Gnumeric_applix:applix       | Applix (*.as)
Gnumeric_sc:sc               | SC/xspread
Gnumeric_XmlIO:gnum_xml      | Gnumeric XML (*.gnumeric)
Gnumeric_lotus:lotus         | Lotus 123 (*.wk1, *.wks, *.123)
Gnumeric_dif:dif             | Data Interchange Format (*.dif)
Gnumeric_mps:mps             | Linear and integer program (*.mps) file format
Gnumeric_sylk:sylk           | MultiPlan (SYLK)
Gnumeric_xml_sax:xml_sax     | EXPERIMENTAL SAX based Gnumeric (*.gnumeric)
Gnumeric_plan_perfect:pln    | Plan Perfect Format (PLN) import
Gnumeric_OpenCalc:openoffice | Open/Star Calc (*.sxc)
Gnumeric_stf:stf_csvtab      | Comma or tab separated values (CSV/TSV)
Gnumeric_stf:stf_assistant   | Text import (configurable)
edd@basebud:~>

Hth, Dirk

> 
> Perhaps you could submit a manual patch making that clear.
> 
> On Mon, 17 Jan 2005, Nicholas Lewin-Koh wrote:
> 
> >Hi,
> >I had some excel files that I needed to read into R, there were alot so
> >I didn't want to
> >do them by hand in gnumeric. I tried all the recommendations in the data
> >import/export manuals, including RODBC,
> >and for some reason they all failed on these files. Then I stumbled on
> >ssconvert, a script that wraps
> >all gnumerics converters, see
> >http://www.gnome.org/projects/gnumeric/doc/sect-files-ssconvert.html. I
> >would
> >suggest adding ssconvert to the import/export manual as an option for
> >excel files. It seems to be very robust.
> 
> -- 
> Brian D. Ripley,                  ripley@stats.ox.ac.uk
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> University of Oxford,             Tel:  +44 1865 272861 (self)
> 1 South Parks Road,                     +44 1865 272866 (PA)
> Oxford OX1 3TG, UK                Fax:  +44 1865 272595
> 
> ______________________________________________
> R-devel@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel

-- 
Better to have an approximate answer to the right question than a precise 
answer to the wrong question.  --  John Tukey as quoted by John Chambers


[Rd] Excel files-suggested manual addition
Dirk Eddelbuettel