disclaimer, can't switch it off)
-Original Message-
From: Prof Brian Ripley [mailto:[EMAIL PROTECTED]
Sent: 24 June 2003 17:54
To: Victor H. Marím
Cc: [EMAIL PROTECTED]
Subject: Re: [R] excel files and R
Security Warning:
If you are not sure an attachment is safe to open please contact
Andy
London EC3V 0HR, U.K.
-Original Message-
From: Simon Fear [mailto:[EMAIL PROTECTED]
Sent: 25 June 2003 09:22
To: [EMAIL PROTECTED]
Subject: RE: [R] excel files and R
RODBC works fine but as far as I can tell requires that the connection
be
opened through Windows menus. OK
To: Victor H. Marím
Cc: [EMAIL PROTECTED]
Subject: Re: [R] excel files and R
Security Warning:
If you are not sure an attachment is safe to open please contact
Andy on x234. There are 0 attachments with this message
H. Marím
Cc: [EMAIL PROTECTED]
Subject: Re: [R] excel files and R
Security Warning:
If you are not sure an attachment is safe to open please contact
Andy on x234. There are 0 attachments with this message
Simon Fear wrote:
RODBC works fine but as far as I can tell requires that the connection
be
opened through Windows menus. OK for a one-off, but not for batch
processing.
Please someone tell me what I missed - how can I open the connection
within
an R script?
(Windows 98)(not my fault)
[snip]
It
And there is Thomas Baier's and my RCOM package
which would allow to run R from within Excel
or exchange data between Excel and R with R
as the main interface.
Morrison, Gordon wrote:
If you really want to run windows from R (in my experience it is much better
to reside entirely within R) then I
read.sas and read.spss. Which is
essentially
what Bernhard Pfaff's recent post offers - thanks again Bernhard - but
using
RODBC instead of foreign.
-Original Message-
From: Erich Neuwirth [mailto:[EMAIL PROTECTED]
Sent: 25 June 2003 10:42
To: Morrison, Gordon; [EMAIL PROTECTED]
Subject: Re: [R
On Wed, 25 Jun 2003, Simon Fear wrote:
Many many thanks. I did look at this but I have absolutely no idea of
the
background so got completely lost. Can you recommend a gentle
introduction/overview to this area, based on the assumption that my
current
knowledge equals zero? Indeed, could you
On 25-Jun-03 Simon Fear wrote:
[...] I think I just want to get the data from Excel ('cos that's how
it nearly always comes), but I don't want to process it in Excel, when
I have R ...
In that case there is a very simple solution (asuming you have access
to Excel).
Open the Excel file in
To: Erich Neuwirth [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:RE: [R] excel files and R
Many many thanks. I did look at this but I have absolutely no idea of
the
background so got completely lost. Can you recommend a gentle
introduction/overview
On Wed, 25 Jun 2003 11:51:44 +0100 (BST), you wrote in message
[EMAIL PROTECTED]:
The Excel .xls format is poorly documented, probably deliberately
obfuscated. A direct interface is on the TODO list: it should be quite
easy in Windows and possible in other OSes (there is code in Gnumeric, for
On Wed, 2003-06-25 at 09:20, Thomas Lumley wrote:
On Wed, 25 Jun 2003, Simon Fear wrote:
I guess all that I and apparently others really want is that foreign
might
include read.excel, like it has read.sas and read.spss. Which is
essentially
what Bernhard Pfaff's recent post offers -
On Wed, Jun 25, 2003 at 10:02:07AM -0500, Marc Schwartz wrote:
Yet another would be Gnumeric, which like Calc is GPL'd and can read and
write native Excel file formats.
The Gretl econometrics package (http://gretl.sf.net) also has a small
library for reading Excel files (in the file
)
-Original Message-
From: Prof Brian Ripley [mailto:[EMAIL PROTECTED]
Sent: 24 June 2003 17:54
To: Victor H. Marím
Cc: [EMAIL PROTECTED]
Subject: Re: [R] excel files and R
Security Warning:
If you are not sure an attachment is safe to open please contact
Andy
For loading Excel data and many others file formats,
one possibility is to use the free conversion utility: DataLoad.
See: http://www.vsn-intl.com/genstat/downloads/datald.htm
(there're probably also other links)
It should be easy to create R wrappers to use that utility.
Cheers
--
Fan
Marc
15 matches
Mail list logo