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" <[EMAIL PROTECTED]>
Subject: [R] importing excel-file
To: <[email protected]>
Message-ID:
<[EMAIL PROTECTED]>
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]]
______________________________________________
[email protected] 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.
