Hello to all, How can I make R read the data from an Excel sheet? thanks, ozlem [[alternative HTML version deleted]]
Ein eingebundener Text mit undefiniertem Zeichensatz wurde abgetrennt. Name: nicht verf?gbar URL: https://stat.ethz.ch/pipermail/r-help/attachments/20070514/92c4a141/attachment.pl
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}}
On Mon, May 14, 2007 at 12:15:12PM +0200, Soare Marcian-Alin wrote:> library(xlsReadWrite) > ?read.xlsI think this is windows only. If you search the mailing list you can find a quite recent discussion on the topic: http://finzi.psych.upenn.edu/R/Rhelp02a/archive/97970.html Gabor> KR, > Alin Soare > > 2007/5/12, Ozlem Ipekci <ozlemipekci at gmail.com>: > > > > Hello to all, > > How can I make R read the data from an Excel sheet? > > thanks, > > ozlem > > > > [[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. > > > > [[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.-- Csardi Gabor <csardi at rmki.kfki.hu> MTA RMKI, ELTE TTK
library(RODBC);
# 1. READ DATA FROM EXCEL INTO R
xlsConnect<-odbcConnectExcel("C:\\temp\\demo.xls");
demo<-sqlFetch(xlsConnect, "Sheet1");
odbcClose(xlsConnect);
rm(demo);
On 5/12/07, Ozlem Ipekci <ozlemipekci at gmail.com>
wrote:> Hello to all,
> How can I make R read the data from an Excel sheet?
> thanks,
> ozlem
>
> [[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.
>
--
WenSui Liu
A lousy statistician who happens to know a little programming
(http://spaces.msn.com/statcompute/blog)