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:[EMAIL PROTECTED] Sent: Friday, January 28, 2005 3:13 PM To: 'Jessica Higgs' Cc: [email protected] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jessica Higgs Sent: 28 January 2005 19:24 To: [email protected] 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. ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
