[R] A question in R
kbartz at loyaltymatrix.com
Tue Oct 12 17:56:45 CEST 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:
> or this:
> but I got:
>  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
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
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?
More information about the R-help