Question

how to import xls file R

0

Entering edit mode

avinash gupta ▴ 130

@avinash-gupta-4042

Last seen 7.7 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 • link updated 13.5 years ago by Steve Lianoglou ★ 13k • written 13.5 years ago by avinash gupta ▴ 130

score 0 · Answer 1 · 2011-05-16

0

Entering edit mode

Steve Lianoglou ★ 13k

@steve-lianoglou-2771

Last seen 20 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 • link 13.5 years ago Steve Lianoglou ★ 13k

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 • link 13.5 years ago Kevin Coombes ▴ 430