[R] A question in R
Prof Brian Ripley
ripley at stats.ox.ac.uk
Tue Oct 12 18:04:16 CEST 2004
Take a look at the `R Data Import/Export' manual.
Hint: if test1.xls is an Excel worksheet, it is not a tab-delimited file.
On Tue, 12 Oct 2004, Yayira har wrote:
> I started to learn the R language, but I didn't suceed to use an external file.
>
> Let say that I have an excel file called "test1.xls" in the directory
> "C:/program files/R/rw2000/external_files" that looks like that:
>
> name mark
> yair 80
> yosi 70 ...
>
> In the appropriate directory I wrote this:
>
> x<-read.delim("test1.xls")
>
> or this:
>
> x<-read.csv("test1.xls")
>
> but I got:
>
> [1] X......
> <0 rows> (or 0-length row.names)
>
> way cannot I read the file? what is the appropriate command for reading an excel file?
>
> I looked at the site of R-project but I didn't find a suitable comand.
>
> __________________________________________________
>
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>
>
--
Brian D. Ripley, ripley at 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
More information about the R-help
mailing list