[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