Re: [R] Import from excel 2007

2007-10-19 Thread Prof Brian Ripley
Now my Windows machine is back online again, I have been able to do some work on this. You can download the latest ODBC drivers from download.microsoft.com (select Office as the product, search for ODBC and you will get to AccessDatabaseEngine.exe). You don't need any version of Office install

Re: [R] Import from excel 2007

2007-10-17 Thread Earl F. Glynn
"Earl F. Glynn" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'll try the odbcDriverConnect and let you know. Thanks. odbcDriverConnect worked fine for me, too, with new Excel 2007 formats: library(RODBC) channel <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.x

Re: [R] Import from excel 2007

2007-10-17 Thread Earl F. Glynn
"Marc Schwartz" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > This might be a question along the lines of "is it plugged in?", but do > you have the Office 2007 version of the ODBC drivers installed? > > If not, then your results would not be a surprise. > > If you do, then we shou

Re: [R] Import from excel 2007

2007-10-17 Thread Marc Schwartz
On Wed, 2007-10-17 at 20:53 +0200, kees wrote: > For me, it works. That is to say, not the simple way, which gave the error: > odbcConnectExcel("C:\\Users\\Kees\\Desktop\\Map1.xlsx") > > But it does when you ask the correct driver > odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx,

Re: [R] Import from excel 2007

2007-10-17 Thread kees
For me, it works. That is to say, not the simple way, which gave the error: odbcConnectExcel("C:\\Users\\Kees\\Desktop\\Map1.xlsx") But it does when you ask the correct driver odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=C:\\Users\\Kees\\Desktop\\Map1.xlsx

Re: [R] Import from excel 2007

2007-10-17 Thread Marc Schwartz
On Wed, 2007-10-17 at 11:53 -0500, Earl F. Glynn wrote: > "Marc Schwartz" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote: > >> Hey Seniors, > >> > >> Really new to R, please has anyone imported a dataset from MS office > >>

Re: [R] Import from excel 2007

2007-10-17 Thread Earl F. Glynn
"Marc Schwartz" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote: >> Hey Seniors, >> >> Really new to R, please has anyone imported a dataset from MS office >> excel 2007 into R yet? It seem to be giving me hard times which I did

Re: [R] Import from excel 2007

2007-10-17 Thread J . delasHeras
Quoting Scionforbai <[EMAIL PROTECTED]>: >> It would be dumb to ignore the fact that Excel is a very widespread >> program, and therefore in the real world we are very likely to >> encounter data formatted by Excel. > > Of course I know the widespreading of such programs. But the point is: > how c

Re: [R] Import from excel 2007

2007-10-17 Thread Scionforbai
> It would be dumb to ignore the fact that Excel is a very widespread > program, and therefore in the real world we are very likely to > encounter data formatted by Excel. Of course I know the widespreading of such programs. But the point is: how can we start to change this in the real world? Peop

Re: [R] Import from excel 2007

2007-10-17 Thread J . delasHeras
Quoting Scionforbai <[EMAIL PROTECTED]>: > I just wonder: why should R and its community try to support such an > awful program, with its protected formats and unmantained > features/bugs? > I mean, from both philosophical and technical point of view: R is free > software and should rather try to

Re: [R] Import from excel 2007

2007-10-17 Thread Hans-Peter
> > The best way to read or write Excel files is with the RExcel package. The Well, I'd argue, that often 'the best way' is to use the xlsReadWrite package, but I am biased... There are some precondition: - you have to be on windows (but my new soon-to-arrive notebook will be a Mac, therefore..

Re: [R] Import from excel 2007

2007-10-16 Thread Gabor Grothendieck
Excel 2007 xlsx files are zip files that contain XML files which define the spreadsheet -- its all readable text. Create an Excel 2007 xlsx file, rename its extension to .zip, unzip it and you can look at all the constituent files using any text editor or your browser. On 10/16/07, Marc Schwartz

Re: [R] Import from excel 2007

2007-10-16 Thread hadley wickham
On 10/16/07, Marc Schwartz <[EMAIL PROTECTED]> wrote: > On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote: > > Hey Seniors, > > > > Really new to R, please has anyone imported a dataset from MS office > > excel 2007 into R yet? It seem to be giving me hard times which I did > > not expect as i

Re: [R] Import from excel 2007

2007-10-16 Thread Rolf Turner
On 17/10/2007, at 7:52 AM, Alberto Monteiro wrote: > Scionforbai wrote: >> >> I just wonder: why should R and its community try to support >> such an awful program, with its protected formats and unmantained >> features/bugs? >> > By such logic, why should R be ported to Windows? :-) > > Short an

Re: [R] Import from excel 2007

2007-10-16 Thread Alberto Monteiro
Scionforbai wrote: > > I just wonder: why should R and its community try to support > such an awful program, with its protected formats and unmantained > features/bugs? > By such logic, why should R be ported to Windows? :-) Short answer: because some of the data you want to use is writen in Excel

Re: [R] Import from excel 2007

2007-10-16 Thread Bert Gunter
o: [EMAIL PROTECTED]; r-help@r-project.org Subject: Re: [R] Import from excel 2007 I just wonder: why should R and its community try to support such an awful program, with its protected formats and unmantained features/bugs? I mean, from both philosophical and technical point of view: R is free softwa

Re: [R] Import from excel 2007

2007-10-16 Thread Scionforbai
I just wonder: why should R and its community try to support such an awful program, with its protected formats and unmantained features/bugs? I mean, from both philosophical and technical point of view: R is free software and should rather try to be 'viral' than to compete. It already has the stren

Re: [R] Import from excel 2007

2007-10-16 Thread Marc Schwartz
On Tue, 2007-10-16 at 19:21 +0200, Scionforbai wrote: > > Such workarounds should normally be avoided. > > You forgot to mention: Excel should normally be avoided. > > Risk of scrambling data while exporting to a simple ascii formatted text file? > Is it a joke? No. Excel is notorious for this.

Re: [R] Import from excel 2007

2007-10-16 Thread Scionforbai
> Such workarounds should normally be avoided. You forgot to mention: Excel should normally be avoided. Risk of scrambling data while exporting to a simple ascii formatted text file? Is it a joke? __ R-help@r-project.org mailing list https://stat.ethz.

Re: [R] Import from excel 2007

2007-10-16 Thread Richard M. Heiberger
The best way to read or write Excel files is with the RExcel package. The development package available from http://sunsite.univie.ac.at/rcom/download/devel/RExcel.installer_1.80-14.zip reads both Excel 2003 and Excel 2007 files. In this development release, the installer is structured as an ord

Re: [R] Import from excel 2007

2007-10-16 Thread Marc Schwartz
On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote: > Hey Seniors, > > Really new to R, please has anyone imported a dataset from MS office > excel 2007 into R yet? It seem to be giving me hard times which I did > not expect as it use to go well with the previous versions. > > Thanks

Re: [R] Import from excel 2007

2007-10-16 Thread Bert Gunter
Please read the Posting Guide and provide reproducible code. What do you mean by "import"? -- via RODBC?... as a delimited text file? ... using read.table(), scan(),... ??? Bert Gunter Genentech Nonclinical Statistics -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]