Re: [R] Rcmdr importing excel files

From: John Fox <jfox_at_mcmaster.ca>
Date: Tue, 26 Feb 2008 17:50:28 -0500

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.



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. Received on Tue 26 Feb 2008 - 22:53:40 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 26 Feb 2008 - 23:30:17 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive