hi!, i'm starting using R and i'd like to know how to import data from an excel format Thank you! ___________________________________________________________ -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
jimmy melinard wrote:> > hi!, > i'm starting using R and i'd like to know how to > import data from an excel format > Thank you!A first point to start is the R Data Import/Export Manual. If you have got a version of excel you don't need to import data from Excel too often, I'd suggest to save the file from Excel an ASCII format, e.g. .csv. There are other ways like ODBC connections (which doesn't work very well with Excel, AFAIK) or the R-Excel Interface provided by Erich Neuwirth, available at CRAN (somewhere in "Other" software). Uwe Ligges -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
In case you have access to Excel, you can open the file and save it in Comma Separated Values format and then read it into R using read.csv. At 05:23 PM 16/7/2002 +0200, jimmy melinard wrote:>hi!, >i'm starting using R and i'd like to know how to >import data from an excel format >Thank you!-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Save your data as a ".txt" file (".cvs", also work). Then in
the R command window type:
object <- read.table("route/to/your/file", header = TRUE)
If any, be sure to include spaces in the route toyour file. The command
"header" is optional, should be included if your data include their
names.
Ulises M. Alvarez
-----------------
Fisica Aplicada y
Tecnologia Avanzada
UNAM - Mexico
umalvarez at fata.unam.mx
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Hello Jimmy,>From Excel I usually save a single worksheet as a comma separated file(CSV), which can easily be imported into R using "read.csv". I believe that other R users take advantage of a COM interface developed for R. Other list members will know how to get that. Regards, Andrew C. Ward CAPE Centre Department of Chemical Engineering The University of Queensland Brisbane Qld 4072 Australia andreww at cheque.uq.edu.au On Wednesday, July 17, 2002 1:23 AM, jimmy melinard [SMTP:jmelinard at yahoo.fr] wrote:> hi!, > i'm starting using R and i'd like to know how to > import data from an excel format > Thank you! > > ___________________________________________________________ > > >-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-. -.-.-.-> r-help mailing list -- Readhttp://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html> Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._ -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._