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

[Prof Brian Ripley]

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