[BioC] how to import xls file R

Kevin R. Coombes kevin.r.coombes at gmail.com
Mon May 16 17:48:31 CEST 2011


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
>



More information about the Bioconductor mailing list