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

[Tony Breyal]

Hi Xin,

I think you can use the read.xls() function from package
xlsReadWrite.

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

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.