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]]
______________________________________________ [EMAIL PROTECTED] 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
______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html