[R] importing excel-file

[Peter Dalgaard]

John Field wrote:
> Corinna,
>
> I find the easiest way to read simple Excel files (under Windows) is 
> to highlight the section of the worksheet I want to read, copy it to 
> the clipboard, and then use
>
> data <- read.delim("clipboard")
>
> You will also need  the parameter dec="," to set the decimal point.
>   
Or use read.delim2, which is what it is for.
> Regards,
> John Field
> Adelaide, SA
>
>
>
> Message: 23
> Date: Wed, 18 Apr 2007 16:10:51 +0200
> From: "Schmitt, Corinna" <Corinna.Schmitt at igb.fraunhofer.de>
> Subject: [R] importing excel-file
> To: <r-help at stat.math.ethz.ch>
> Message-ID:
>          <8B7B0FD99E8AF541A21609104D1961589128BD at izs-xchg01.izs.fraunhofer.de>
> Content-Type: text/plain; charset="us-ascii"
> Dear R-experts,
> It is a quite stupid question but please help me. I am very confuced. I
> am able to import normal txt ant mat-files to R but unable to import
> .xls-file
> I do not understand the online help. Can please anyone send me the
> corresponding command lines? The .xls-file is attached. In my file we
> use commas for the decimal format (example: 0,712), changes might be
> needed.
> Thanks, Corinna
>
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> 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
> and provide commented, minimal, self-contained, reproducible code.
>   


-- 
   O__  ---- Peter Dalgaard             Øster Farimagsgade 5, Entr.B
  c/ /'_ --- Dept. of Biostatistics     PO Box 2099, 1014 Cph. K
 (*) \(*) -- University of Copenhagen   Denmark          Ph:  (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)                  FAX: (+45) 35327907