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 [EMAIL PROTECTED]:~> 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 [EMAIL PROTECTED]:~> 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) [EMAIL PROTECTED]:~> 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, [EMAIL PROTECTED] > 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 ______________________________________________ R-devel@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
