R help - Jan 2009 - how to read data from the different worksheets in the same Excel file

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

The read.xls function the gdata package has a sheet= argument.

On Wed, Jan 14, 2009 at 6:30 AM, Xin Shi <jasonshi510 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-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.
>

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.