[R] Excel data into R

Millo Giovanni Giovanni_Millo at Generali.com
Mon May 14 12:19:52 CEST 2007


Ozlem,
three ways of doing this, AFAIK:

1) save Excel data as tab-delimited values in a .txt file and please see
?read.table (you will need to set 'sep="\t"')
2) check the xlsReadWrite package out, very handy!
3) see the R-DCOM server and related software by Bayer and Neuwirth, but
this is overkill as their package is much more than a reading interface.
It can do that as well, anyway.

Solution 2) is definitely the quickest.
Cheers,
Giovanni

Giovanni Millo
Research Dept.,
Assicurazioni Generali SpA
Via Machiavelli 4, 
34131 Trieste (Italy)
tel. +39 040 671184 
fax  +39 040 671160 

Original message: 
------------------------------

Message: 40
Date: Sat, 12 May 2007 23:00:29 +0300
From: "Ozlem Ipekci" <ozlemipekci at gmail.com>
Subject: 
To: R-help at stat.math.ethz.ch
Message-ID:
	<ea0349ad0705121300reed396dldb3736021a7aad54 at mail.gmail.com>
Content-Type: text/plain

Hello to all,
How can I make R read the data from an Excel sheet?
thanks,
ozlem

	[[alternative HTML version deleted]]



------------------------------
 
Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni ...{{dropped}}



More information about the R-help mailing list