[R] Rcmdr importing excel files

John Fox jfox at mcmaster.ca
Tue Feb 26 23:50:28 CET 2008


Dear John and Stephen,

As I recall, importing from Excel, Access, or dBase files works properly
only under Windows, and consequently the menu item appears only in Windows
systems. I frankly don't recall why this is the case, since the RODBC
package is used. The code for reading these kinds of files was contributed
by Matthieu Lesnoff, to whom I'm copying this response. Maybe he'll have a
more complete answer.

Regards,
 John

--------------------------------
John Fox, Professor
Department of Sociology
McMaster University
Hamilton, Ontario, Canada L8S 4M4
905-525-9140x23604
http://socserv.mcmaster.ca/jfox

> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of John Kane
> Sent: February-26-08 5:27 PM
> To: stephen sefick; r-help at r-project.org
> Subject: Re: [R] Rcmdr importing excel files
> 
> I'm on Windows XP R 2.6.2
> The command
> Data > Import > From Excel, Access etc
> Supply data.frame name
> Select xls file and then select the sheet seem to work
> for me
> 
> What is not showing?
> --- stephen sefick <ssefick at gmail.com> wrote:
> 
> > I am using R 2.6.2 on Mac OS X 10.4.9-  I would like
> > to import excel
> > files into R with Rcmdr, but This option does not
> > present itself in
> > the file menu.  Any help would be greatly
> > appreciated.
> >
> > Stephen
> >
> > --
> > Let's not spend our time and resources thinking
> > about things that are
> > so little or so large that all they really do for us
> > is puff us up and
> > make us feel like gods.  We are mammals, and have
> > not exhausted the
> > annoying little problems of being mammals.
> >
> > 								-K. Mullis
> >
> > ______________________________________________
> > R-help at 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 at 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.



More information about the R-help mailing list