You should RODBC library. It has some functions to fetch data from excel.
You can use the following code


>channel<-odbcConnectExcel("filename.xls")  # replace filename with the name
of ur file
>xldata<-sqlFetch(channel,"excel sheet name", colnames = T)

hope this helps

Regards,
Rana Shoaaib Mehmood


On Nov 30, 2007 7:23 AM, Gabor Grothendieck <ggrothendieck@gmail.com> wrote:

> Or even:
>
> clip <- function() read.delim("clipboard", header =
>  is.na(suppressWarnings(as.numeric(scan("clipboard", "", 1)))))
>
> On Nov 29, 2007 7:51 PM,  <apjaworski@mmm.com> wrote:
> > Here is a very crude function I use quite often.  It tries to recognize
> > whether you have headers or not by checking the very first character.
>  If
> > it is numeric, it assumes that there are no headers. The
> suppressWarnings
> > gets rid of a warning one gets when trying to coerce a character to
> > numeric.   The main advantage of the function is that you do not have to
> > type too much :-)
> >
> > clip <- function(){
> >    if(is.na(suppressWarnings(as.numeric(scan("clipboard", what="",
> > nmax=1)))))
> >       read.delim("clipboard")
> >    else
> >       read.delim("clipboard", header=FALSE)
> >
> > Cheers,
> >
> > Andy
> >
> > __________________________________
> > Andy Jaworski
> > 518-1-01
> > Process Laboratory
> > 3M Corporate Research Laboratory
> > -----
> > E-mail: apjaworski@mmm.com
> > Tel:  (651) 733-6092
> > Fax:  (651) 736-3122
> >
> >
> >
> >             Bert Gunter
> >             <gunter.berton@ge
> >             ne.com>
>  To
> >             Sent by:                  "'Gabor Grothendieck'"
> >             r-help-bounces@r-         <ggrothendieck@gmail.com>
> >             project.org
>  cc
> >                                       r-help@r-project.org
> >
> Subject
> >             11/29/2007 06:39          Re: [R] MS Excel Data
> >             PM
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Better yet! Thanks Gabor.
> >
> > -- Bert
> >
> > -----Original Message-----
> > From: Gabor Grothendieck [mailto:ggrothendieck@gmail.com]
> > Sent: Thursday, November 29, 2007 12:10 PM
> > To: Bert Gunter
> > Cc: r-help@r-project.org
> > Subject: Re: [R] MS Excel Data
> >
> > On Nov 29, 2007 3:01 PM, Bert Gunter <gunter.berton@gene.com> wrote:
> > > This has been discussed on this list many times before. Google on
> "Import
> > > Excel R". Note also that there are potential problems (loss of digits)
> > due
> > > to Excel "idiosyncracies" depending on what you do.
> > > http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html
> > provides
> > > some details.
> > >
> > > Finally, I have found that for rectangular data sets with no missing
> > fields
> > > in Excel (tables), cutting and read.tabling **the data only ** is a
> > > simple(but probably not without risk) way to do it:
> > >
> > > (after cutting the data only in Excel to the clipboard) in R:
> > >
> > > newdat <- read.table("clipboard", head=FALSE, row.names=NULL)
> > >
> > > The columns can then be named via names(newdat) <- ...
> > >
> > > I omit column headers because in most of the Excel data I get the
> column
> > > names have spaces and other non-alphanumeric characters which R cannot
> > > easily digest. One could separately scan() just the vector of column
> > headers
> > > and use regular expressions to extract the names. But for small
> tables, I
> > > find it easier just to create the names manually.
> >
> > You can include headers with spaces in the copy with:
> >
> >    DF <- read.delim("clipboard")
> >
> >
> > ______________________________________________
> > R-help@r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> > http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
> >
> >
> >
> >
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



-- 
Regards,
Rana Shoaaib Mehmood
(+92) 333 550 4531

	[[alternative HTML version deleted]]

