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 Schwar
ut 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)
> > >
> > > TIA
> > > (sorry for long dis
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 plugin/exc
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 po
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,
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 - thanks again Bernhard - but
> using
> RODBC instead
CTED]
06/25/2003 06:16 AM
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. C
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 Ex
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, coul
[EMAIL PROTECTED]
Subject: Re: [R] excel files and R
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 ex
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 th
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 is
t; (sorry for long 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] e
of 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 op
t; 60 Gracechurch Street
> 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 connec
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
An
On Tue, 24 Jun 2003, Victor H. Marím wrote:
> I am new at R. My questions is rather basic. Looking R manuals looks
> like there should be a way to read MS excel files into R. Could
> somebody tell me which library should I use for that?
Several ways are in the R Data Import/Export Manual (the
Greetings everyone,
I am new at R. My questions is rather basic. Looking R manuals looks
like there should be a way to read MS excel files into R. Could
somebody tell me which library should I use for that?
Thanks in advance
Victor H. Marín
Laboratorio de Modelación Ecológica
Depto. de Cie
18 matches
Mail list logo