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" <[EMAIL PROTECTED]> 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 > > [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
