[R] Excel data into R

[Wensui Liu]

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)