how to read data from the different worksheets in the same Excel file

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... at 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... at 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 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.

Brian D. Ripley,                  ripley at 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

how to read data from the different worksheets in the same Excel file

Thread (2 messages)