how to import xls file R
1
0
Entering edit mode
avinash gupta ▴ 130
@avinash-gupta-4042
Last seen 7.8 years ago
hello group, i have problem to understand that how to import any exel file in R.please any help me with any example. thank you Regards Avinash Gupta BCS-In Silico Biology Lucknow 8604401063 9654213253 [[alternative HTML version deleted]]
• 1.4k views
ADD COMMENT
0
Entering edit mode
@steve-lianoglou-2771
Last seen 22 months ago
United States
Hi, On Mon, May 16, 2011 at 2:59 AM, avinash gupta <gupta308 at="" gmail.com=""> wrote: > hello group, > > i have problem to understand that how to import any exel file in R.please > any help me with any example. > thank you One way is to export the fie from Excel as a comma (or tab) delimited file, and use R's read.table (and friends) functions to import the delimited file into R. There's also more advice here: http://cran.r-project.org/doc/manuals/R-data.html#Reading-Excel- spreadsheets -steve -- Steve Lianoglou Graduate Student: Computational Systems Biology ?| Memorial Sloan-Kettering Cancer Center ?| Weill Medical College of Cornell University Contact Info: http://cbio.mskcc.org/~lianos/contact
ADD COMMENT
0
Entering edit mode
Alternatively, install the gdata package and then do library(gdata) mydata <- read.xls("myfile.xls", sheet=1) On 5/16/2011 8:39 AM, Steve Lianoglou wrote: > Hi, > > On Mon, May 16, 2011 at 2:59 AM, avinash gupta<gupta308 at="" gmail.com=""> wrote: >> hello group, >> >> i have problem to understand that how to import any exel file in R.please >> any help me with any example. >> thank you > One way is to export the fie from Excel as a comma (or tab) delimited > file, and use R's read.table (and friends) functions to import the > delimited file into R. > > There's also more advice here: > > http://cran.r-project.org/doc/manuals/R-data.html#Reading-Excel- spreadsheets > > -steve >
ADD REPLY

Login before adding your answer.

Traffic: 709 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6