Would this function be useful to you. This imports the data from an excel
file and gives it to you as a data frame.
http://www.maths.lth.se/help/R/.R/library/gdata/html/read.xls.html
"I have no data yet. It is a capital mistake to theorize before one has
data. Insensibly one begins to twist facts to suit theories instead of
theories to suit facts."
~ Sir Arthur Conan Doyle (1859-1930), Sherlock Holmes
-----Original Message-----
From: dr mike [mailto:dr.mike at ntlworld.com]
Sent: Friday, January 28, 2005 3:13 PM
To: 'Jessica Higgs'
Cc: R-help at stat.math.ethz.ch
Subject: RE: [R] using RODBC
Have you consulted the R Data Import/Export Manual, available from the Rgui
via the Help tab?
Mike
-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch
[mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Jessica Higgs
Sent: 28 January 2005 19:24
To: R-help at stat.math.ethz.ch
Subject: [R] using RODBC
I am trying to bring data into R from an excel spreadsheet in order to
perform several statistical tests on it. I was trying to use
odbcConnectExcel in the RODBC package. Once I am connected to the excel
file, how do I select rows and columns from the file in order to analysis
them in R.
______________________________________________
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
______________________________________________
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