[R] how to extract data from excel sheet?

Petr Pikal petr.pikal at precheza.cz
Thu Aug 19 13:34:00 CEST 2004



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 area with your data 
(preferably with abbreviated names in collumn headings), press 
Ctrl-C, open R, go to command window, type:

mysheet <- read.delim("clipboard")

read suggested documentation and help pages.

Cheers
Petr

> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html

Petr Pikal
petr.pikal at precheza.cz




More information about the R-help mailing list