From nikko at hailmail.net  Tue Jan 18 03:12:33 2005
From: nikko at hailmail.net (Nicholas Lewin-Koh)
Date: Tue Jan 18 03:12:44 2005
Subject: [Rd] Excel files-suggested manual addition
In-Reply-To: <20050117220421.GA1302@sonny.eddelbuettel.com>
References: <1105997042.4379.212944892@webmail.messagingengine.com>
	<Pine.LNX.4.61.0501172151360.9155@gannet.stats>
	<20050117220421.GA1302@sonny.eddelbuettel.com>
Message-ID: <1106014353.28723.212962592@webmail.messagingengine.com>

Hi,
Sorry I should have included that I was converting from excel (.xls) to 
comma seperated values (.csv) for import to R. Also of note is that 
gnumeric 1.4.1 for windows in at release candidate 5, and should be
relesed very soon. I believe ssconvert will also work on windows.


Nicholas
On Mon, 17 Jan 2005 16:04:21 -0600, "Dirk Eddelbuettel" <edd@debian.org>
said:
> 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
Nicholas Lewin-Koh