[R] how to extract data from excel sheet?

i want to upload different sheets from one excel file. does anyone know of a way to do so? (i use read.csv to load the excel but i would like to load form the sheets themselves.) thanks sivan __ [EMAIL PROTECTED] mailing list

Re: [R] how to extract data from excel sheet?

Sivan Aldor wrote: i want to upload different sheets from one excel file. does anyone know of a way to do so? Yes, the R Data Import/Export manual knows. Uwe Ligges (i use read.csv to load the excel but i would like to load form the sheets themselves.) thanks sivan

Re: [R] how to extract data from excel sheet?

Hi, Take a look at read.xls() from gregmisc package. HTH, Kevin On Thu, 19 Aug 2004, Sivan Aldor wrote: i want to upload different sheets from one excel file. does anyone know of a way to do so? (i use read.csv to load the excel but i would like to load form the sheets themselves.) thanks

Re: [R] how to extract data from excel sheet?

Here is one way to read the mysheet1 worksheet from the mydata.xls file: library(RODBC) z - odbcConnectExcel(c:\\mydata.xls) myframe - sqlFetch(z, mysheet1) close(z) Your data will be in myframe. Thanks to Michael Lapsley and Brian Ripley for the RODBC package. See the R

Re: [R] how to extract data from excel sheet?

On 19 Aug 2004 at 12:05, Sivan Aldor wrote: i want to upload different sheets from one excel file. does anyone know of a way to do so? (i use read.csv to load the excel but i would like to load form the sheets themselves.) thanks sivan Hi Open Excel, go to the sheet, select rectangular