[R] A question in R
Yves Magliulo
ym at climpact.com
Tue Oct 12 18:14:13 CEST 2004
hi,
check R-data import/export document at this link
cran.r-project.org/doc/manuals/R-data.pdf
let me give you an advice for further questions : it's easiest to find
answer to your question searching directly with google
--
------
Yves Magliulo <ym at climpact.com>
R&D Engineer, CLIMPACT
Tel. : +33 (0) 1 44 27 34 31
Fax. : +33 (0) 1 44 27 49 96
Universite Pierre et Marie Curie
Boite 101 - Tour 45 - 5eme etage - Couloir 45/46
4 place Jussieu, 75252 Paris CEDEX 05, France
Le mar 12/10/2004 à 17:56, Kevin Bartz a écrit :
> 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
>
> ______________________________________________
> 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
More information about the R-help
mailing list