trouble with reading data from excel
Hi
On 12 Sep 2005 at 15:23, Wensui Liu wrote:
Sloan,
You don't need to save xls as csv. Actually, R reads data in excel
very well. Following code is cutted from my blog and HTH.
library(RODBC);
###########################################################
# 1. READ DATA FROM EXCEL INTO R #
###########################################################
xlsConnect<-odbcConnectExcel("C:\\temp\\demo.xls");
demo<-sqlFetch(xlsConnect, "Sheet1");
odbcClose(xlsConnect);
rm(demo);
or if you are on Windows
open Excel
select what you want to read, including header
press ctrl-C
in R
mydata<-read.delim("clipboard")
to write from R
write.table(tab, "clipboard", sep = "\t", row.names = F)
open Excel
press ctrl-V
HTH
Petr
On 9/12/05, sloan jones <sledepi at operamail.com> wrote:
I have been trying to open data that I have saved in an excel spread
sheet. I saved it as a csv. Then I tried using the read.csv command.
However, everytime I do this--
diseasedat<-read.csv("M:/sloan/R/disease/disease.csv", sep=, header
= TRUE, fill= TRUE)--
I get an error message:
Error in file(file, "r") : unable to open connection
In addition: Warning message:
cannot open file 'M:/sloan/R/disease/disease.csv'
What am I doing wrong or what should I look for to correct this?
Sloan
--
_______________________________________________ Surf the Web in a faster, safer and easier way: Download Opera 8 at http://www.opera.com ______________________________________________ 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
-- WenSui Liu (http://statcompute.blogspot.com) Senior Decision Support Analyst Cincinnati Children Hospital Medical Center [[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
Petr Pikal petr.pikal at precheza.cz