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

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

Re: [R] 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. 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 he

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

The read.xls function the gdata package has a sheet= argument. On Wed, Jan 14, 2009 at 6:30 AM, Xin Shi 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 thi