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.

Regards,
John Field
Adelaide, SA



Message: 23
Date: Wed, 18 Apr 2007 16:10:51 +0200
From: "Schmitt, Corinna" <Corinna.Schmitt@igb.fraunhofer.de>
Subject: [R] importing excel-file
To: <r-help@stat.math.ethz.ch>
Message-ID:
         <8B7B0FD99E8AF541A21609104D1961589128BD@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]]

