Hi Every one, I have a problem with Reading Excel file into R 2.9.0 version. In older versions it is working with "xlsReadWrite" package. But in 2.9.0 version there is no package like that. so help me out in this aspect. Thanks in Advance. -- View this message in context: http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html Sent from the R help mailing list archive at Nabble.com.
You can download it from http://treetron.googlepages.com/xlsreadwrite.htm Also, you may have a look at Data import/export manual, which has a relevant section. Ronggui 2009/8/11 rajclinasia <raj at clinasia.com>:> > Hi Every one, > I have a problem with Reading Excel file into R 2.9.0 version. In older > versions it is working with "xlsReadWrite" package. But in 2.9.0 version > there is no package like that. so help me out in this aspect. > > Thanks in Advance. > -- > View this message in context: http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- HUANG Ronggui, Wincent PhD Candidate Dept of Public and Social Administration City University of Hong Kong Home page: http://asrr.r-forge.r-project.org/rghuang.html
Hi, take a look at the gdata package (any plataform) function read.xls(), and at the package RODBC (if you are on a Windows Plataform) at the functions odbcConnectExcel(), odbcConnectExcel2007() and sqlFetch(). Hope this helps Rodrigo. 2009/8/11 rajclinasia <raj@clinasia.com>> > Hi Every one, > I have a problem with Reading Excel file into R 2.9.0 version. In older > versions it is working with "xlsReadWrite" package. But in 2.9.0 version > there is no package like that. so help me out in this aspect. > > Thanks in Advance. > -- > View this message in context: > http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]
Use odbcConnectExcel() in the RODBC package. rajclinasia wrote:> > Hi Every one, > I have a problem with Reading Excel file into R 2.9.0 version. In older > versions it is working with "xlsReadWrite" package. But in 2.9.0 version > there is no package like that. so help me out in this aspect. > > Thanks in Advance. >-- View this message in context: http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24918693.html Sent from the R help mailing list archive at Nabble.com.