Currently I have to convert all my "xls" into "csv" before I can read it in and process the excel data in R... Is there a way to directly read in "xls" data? Thanks a lot! [[alternative HTML version deleted]]
Have a look at the read.xls() in gdata package. HTH, Kevin Michael wrote:> Currently I have to convert all my "xls" into "csv" before I can read it in > and process the excel data in R... > > Is there a way to directly read in "xls" data? > > Thanks a lot! > > [[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-- Ko-Kang Kevin Wang Homepage: http://wwwmaths.anu.edu.au/~wangk/ Ph (W): +61-2-6125-2431 Ph (H): +61-2-6125-7471 Ph (M): +61-40-451-8301
Read the manual _R Data Import/Export_ which is shipped with R.The section "8 Reading Excel spreadsheets" will tell what you want. 2006/4/20, Michael <comtech.usa at gmail.com>:> Currently I have to convert all my "xls" into "csv" before I can read it in > and process the excel data in R... > > Is there a way to directly read in "xls" data? > > Thanks a lot! > > [[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 >-- ?????? Deparment of Sociology Fudan University
See: http://finzi.psych.upenn.edu/R/doc/manual/R-data.html#Reading-Excel-spreadsheets Also the RDCOMClient package (find it via google) and rcom (on CRAN) can control Excel from R and can be used. On 4/19/06, Michael <comtech.usa at gmail.com> wrote:> Currently I have to convert all my "xls" into "csv" before I can read it in > and process the excel data in R... > > Is there a way to directly read in "xls" data? > > Thanks a lot! > > [[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 >