Skip to content

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

2 messages · Tony, Brian Ripley

#
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:
#
On Wed, 14 Jan 2009, Tony Breyal wrote:

            
Assuming this is Windows ....
There has been for quite some time.

And this is all in the 'R Data Import/Export' manual ....