[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