On Wed, 14 Jan 2009, Tony Breyal wrote:
Hi Xin,
I think you can use the read.xls() function from package
xlsReadWrite.
Assuming this is Windows ....
alternatively, i think the odbcConnectExcel() function in package
RODBC might work too (not sure about excel 2007 files, though there
might be an updated function for those types of files in the package).
There has been for quite some time.
And this is all in the 'R Data Import/Export' manual ....
Hope that helps a little bit,
Tony Breyal
On 14 Jan, 11:30, "Xin Shi" <jasonshi...@hotmail.com> wrote:
Dear All:
I am trying to read the data from the different sheet but in the same Excel
file. Does R provide this kind of command to do it?
Anyone has experience on this?
Thanks!
Xin
[[alternative HTML version deleted]]
______________________________________________
r-h...@r-project.org mailing listhttps://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guidehttp://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
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.
--
Brian D. Ripley, rip...@stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595
______________________________________________
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.