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.
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 stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! R-project.org/posting-guide.html
Would this function be useful to you. This imports the data from an excel file and gives it to you as a data frame. 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 stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! R-project.org/posting-guide.html ______________________________________________ R-help at stat.math.ethz.ch mailing list stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! R-project.org/posting-guide.html