[R] A question in R

[Kevin Bartz]

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
> 

Hi Yayiya,

R looks less than fondly on Excel files. The easiest solution for you 
will be to export your Excel file to a tab-delimited text format (Save 
-> (.txt) Tab-delimited Text), and then use read.delim as you did. Does 
that make sense?

Kevin