Re: [R] excel files and R

[Fan]

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 Schwartz wrote:
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 - thanks again Bernhard - but
using
RODBC instead of foreign.
It would be nice, but it's quite hard to read Excel off Windows.

The formats in foreign are either documented by the vendor (accurately in
the case of Stata and Epi Info, with some omissions for SAS XPORT) or that
have been reverse-engineered by someone else (read.spss is based on
PSPP, an attempt at an SPSS clone by Ben Pfaaf, and I think Duncan
Murdoch did read.S).
While it isn't usual to say nice things about commercial vendors on these
lists I would like to note that Stata not only documents its file format
in its manuals (with some helpful C snippets for the trickier parts), but
made available the file format for their `large data set' version 7/SE,
which I didn't buy.
	-thomas


Simon,

To add to Thomas' comments and respond to your thoughts, if one were so
inclined, given that R is a volunteer effort, I suspect that an addition
to 'foreign' for Excel would indeed be appreciated by many users.
One resource, with appropriate attribution given, would be the source
code for OpenOffice.org's (OOo) Calc. Since Calc can read and write
Excel formats without using Windows/Office DLL's, it seems reasonable to
presume that OOo has reverse engineered the native Excel file structure.
Since OOo's source is available under the GPL, this could provide the
basis for a "read.excel" function.
Yet another would be Gnumeric, which like Calc is GPL'd and can read and
write native Excel file formats.
More information is available at:

http://www.openoffice.org/dev_docs/source/1.0.3/source.html

http://www.gnome.org/projects/gnumeric/

Food for thought...   :-)

Regards,

Marc Schwartz

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Norm Phillips]

I have to remove the dollar sign from the end of the sheet names.

> 
> > 
> > There's a function odbcConnectExcel, a wrapper to odbcDriverConnect.
> > Neither require any work with Windows menus.
> > 
> Try the following sample script and save it as "foo.R":
> 
> library(RODBC)
> chan1 <- odbcConnectExcel("your-file.xls")
> aa <- sqlFetch(chan1, "Name of your sheet")
> names(aa)
> close(chan1)
> 
> as batch:
> Rterm --no-restore --no-save < foo.R
> 
> works for me, at least.
> 
> 
> HTH,
> Bernhard
> 
> 
> 
> 
> > On Wed, 25 Jun 2003, 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)
> > > 
> > > TIA
> > >  (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] 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.
> > > 
> > > 
> > > 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 
> > obvious manual,
> > > I
> > > would have thought).  If you are working on Windows, 
> using RODBC is
> > > perhaps the simplest.
> > > 
> > > 
> > 
> > -- 
> > Brian D. Ripley,  [EMAIL PROTECTED]
> > Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> > University of Oxford, Tel:  +44 1865 272861 (self)
> > 1 South Parks Road, +44 1865 272866 (PA)
> > Oxford OX1 3TG, UKFax:  +44 1865 272595
> > 
> > __
> > [EMAIL PROTECTED] mailing list
> > https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> > 
> 
> 
> --
> If you have received this e-mail in error or wish to read our e-mail 
> disclaimer statement and monitoring policy, please refer to 
> http://www.drkw.com/disc/email/ or contact the sender.
> 
> __
> [EMAIL PROTECTED] mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> 

[[alternative HTML version deleted]]

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

Re: [R] excel files and R

[Dirk Eddelbuettel]

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/excel_import.c), its
code goes back to

/*
  Based on xls2csv (David Rysdam, 1998), as distributed in the 
  "catdoc" package by Vitus Wagner, with help from the Gnumeric
  excel plugin by Michael Meeks.
 */
  
I have meant to muck with this for some time now, but this is a very low
priority item for me and other things keep popping up.

Dirk

-- 
Don't drink and derive. Alcohol and analysis don't mix.

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Marc Schwartz]

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 - thanks again Bernhard - but
> > using
> > RODBC instead of foreign.
> >
> 
> It would be nice, but it's quite hard to read Excel off Windows.
> 
> The formats in foreign are either documented by the vendor (accurately in
> the case of Stata and Epi Info, with some omissions for SAS XPORT) or that
> have been reverse-engineered by someone else (read.spss is based on
> PSPP, an attempt at an SPSS clone by Ben Pfaaf, and I think Duncan
> Murdoch did read.S).
> 
> 
> While it isn't usual to say nice things about commercial vendors on these
> lists I would like to note that Stata not only documents its file format
> in its manuals (with some helpful C snippets for the trickier parts), but
> made available the file format for their `large data set' version 7/SE,
> which I didn't buy.
> 
> 
>   -thomas


Simon,

To add to Thomas' comments and respond to your thoughts, if one were so
inclined, given that R is a volunteer effort, I suspect that an addition
to 'foreign' for Excel would indeed be appreciated by many users.

One resource, with appropriate attribution given, would be the source
code for OpenOffice.org's (OOo) Calc. Since Calc can read and write
Excel formats without using Windows/Office DLL's, it seems reasonable to
presume that OOo has reverse engineered the native Excel file structure.
Since OOo's source is available under the GPL, this could provide the
basis for a "read.excel" function.

Yet another would be Gnumeric, which like Calc is GPL'd and can read and
write native Excel file formats.

More information is available at:

http://www.openoffice.org/dev_docs/source/1.0.3/source.html

http://www.gnome.org/projects/gnumeric/


Food for thought...   :-)

Regards,

Marc Schwartz

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

Re: [R] excel files and R

[Duncan Murdoch]

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
>example).  In any case, this is a lot harder than the interfaces currently 
>in foreign.

The OpenOffice web site has reasonably complete documentation on this
web page:  .  It skips some of the more
obscure features, but those probably wouldn't be of interest to R
either.

It looks to me as though it would be relatively easy to write (in R,
using the streams code) a reader that could read strings and numbers.
Interpreting formulas would be a lot harder.  (It's possible the last
value of a formula is stored in the .xls file, in which case it would
be easily read too.)

One thing I'm not sure about:  recent .xls versions store strings in
Unicode.  Does R have cross-platform Unicode support?

Duncan

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Thomas Lumley]

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 of foreign.
>

It would be nice, but it's quite hard to read Excel off Windows.

The formats in foreign are either documented by the vendor (accurately in
the case of Stata and Epi Info, with some omissions for SAS XPORT) or that
have been reverse-engineered by someone else (read.spss is based on
PSPP, an attempt at an SPSS clone by Ben Pfaaf, and I think Duncan
Murdoch did read.S).


While it isn't usual to say nice things about commercial vendors on these
lists I would like to note that Stata not only documents its file format
in its manuals (with some helpful C snippets for the trickier parts), but
made available the file format for their `large data set' version 7/SE,
which I didn't buy.


-thomas

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[partha_bagchi]

Simon,

Here is what I do when I encounter an excel spreadsheet. I save it as a 
CSV file (in excel -> save as -> file type CSV) and then read the 
corresponding file into R using read.csv.

Hope that helps,
Partha





"Simon Fear" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
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. Can you recommend a gentle
introduction/overview to this area, based on the assumption that my
current
knowledge equals zero? Indeed, could you make an argument that I should
ever
*want* to run R from within Excel or vice versa? 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 ...

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 of foreign.


-Original Message-
From: Erich Neuwirth [mailto:[EMAIL PROTECTED]
Sent: 25 June 2003 10:42
To: Morrison, Gordon; [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 experience it is much
better
> to reside entirely within R) then I think that you need to use Duncan
Temple
> Lang's RDCOM package ( http://www.omegahat.org/ ). It works well and
> robustly for connections to other packages and I have tested it for
Excel.

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help


Simon Fear
Senior Statistician
Syne qua non Ltd
Tel: +44 (0) 1379 69
Fax: +44 (0) 1379 65
email: [EMAIL PROTECTED]
web: http://www.synequanon.com

Number of attachments included with this message: 0

This message (and any associated files) is confidential and\...{{dropped}}

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Ted Harding]

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 Excel, and save it out as a comma-separated file
(.csv). You may need to clean this up a bit (depending on how sloppily
it was created -- a lot of people create very messy Excel files), but
usually you don't. (For the same reason, it can be best to do the export
to CSV yourself, rather than asking the sender to send you a CSV file,
unless you trust their competence.)

Then, in R, do something like

  X <- read.csv("excelfile.csv")

You will then have a dataframe X (with variables named as in the column
names in the Excel file).

This is what I always do when I get Excel files; it has always worked.

See ?read.csv for options.

Best wishes,
Ted.



E-Mail: (Ted Harding) <[EMAIL PROTECTED]>
Fax-to-email: +44 (0)870 167 1972
Date: 25-Jun-03   Time: 12:20:54
-- XFMail --

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Prof Brian Ripley]

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 make an argument that I should
> ever
> *want* to run R from within Excel or vice versa? 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 ...
> 
> 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 of foreign.

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
example).  In any case, this is a lot harder than the interfaces currently 
in foreign.

-- 
Brian D. Ripley,  [EMAIL PROTECTED]
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel:  +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UKFax:  +44 1865 272595

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Simon Fear]

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 make an argument that I should
ever
*want* to run R from within Excel or vice versa? 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 ...

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 of foreign.


-Original Message-
From: Erich Neuwirth [mailto:[EMAIL PROTECTED]
Sent: 25 June 2003 10:42
To: Morrison, Gordon; [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 experience it is much
better
> to reside entirely within R) then I think that you need to use Duncan
Temple
> Lang's RDCOM package ( http://www.omegahat.org/ ). It works well and
> robustly for connections to other packages and I have tested it for
Excel.

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
 

Simon Fear
Senior Statistician
Syne qua non Ltd
Tel: +44 (0) 1379 69
Fax: +44 (0) 1379 65
email: [EMAIL PROTECTED]
web: http://www.synequanon.com
 
Number of attachments included with this message: 0
 
This message (and any associated files) is confidential and\...{{dropped}}

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

Re: [R] excel files and R

[Erich Neuwirth]

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 think that you need to use Duncan Temple
Lang's RDCOM package ( http://www.omegahat.org/ ). It works well and
robustly for connections to other packages and I have tested it for Excel.
__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

Re: [R] excel files and R

[Renaud Lancelot]

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 no longer true since Pr Ripley provided a function 
odbcConnectExcel() (as well as odbcConnectAccess() and others) in the 
latest version of package RODBC. See the help file(s).

Best,

Renaud

--
Dr Renaud Lancelot, vétérinaire
CIRAD, Département Elevage et Médecine Vétérinaire (CIRAD-Emvt)
Programme Productions Animales
http://www.cirad.fr/fr/pg_recherche/page.php?id=14
ISRA-LNERV  tel+221 832 49 02
BP 2057 Dakar-Hann  fax+221 821 18 79 (CIRAD)
Senegal e-mail [EMAIL PROTECTED]
__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Pfaff, Bernhard]

> 
> There's a function odbcConnectExcel, a wrapper to odbcDriverConnect.
> Neither require any work with Windows menus.
> 
Try the following sample script and save it as "foo.R":

library(RODBC)
chan1 <- odbcConnectExcel("your-file.xls")
aa <- sqlFetch(chan1, "Name of your sheet")
names(aa)
close(chan1)

as batch:
Rterm --no-restore --no-save < foo.R

works for me, at least.


HTH,
Bernhard




> On Wed, 25 Jun 2003, 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)
> > 
> > TIA
> >  (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] 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.
> > 
> > 
> > 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 
> obvious manual,
> > I
> > would have thought).  If you are working on Windows, using RODBC is
> > perhaps the simplest.
> > 
> > 
> 
> -- 
> Brian D. Ripley,  [EMAIL PROTECTED]
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> University of Oxford, Tel:  +44 1865 272861 (self)
> 1 South Parks Road, +44 1865 272866 (PA)
> Oxford OX1 3TG, UKFax:  +44 1865 272595
> 
> __
> [EMAIL PROTECTED] mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
> 


--
If you have received this e-mail in error or wish to read our e-mail 
disclaimer statement and monitoring policy, please refer to 
http://www.drkw.com/disc/email/ or contact the sender.

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Prof Brian Ripley]

There's a function odbcConnectExcel, a wrapper to odbcDriverConnect.
Neither require any work with Windows menus.

On Wed, 25 Jun 2003, 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)
> 
> TIA
>  (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] 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.
> 
> 
> 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 obvious manual,
> I
> would have thought).  If you are working on Windows, using RODBC is
> perhaps the simplest.
> 
> 

-- 
Brian D. Ripley,  [EMAIL PROTECTED]
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel:  +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UKFax:  +44 1865 272595

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Morrison, Gordon]

If you really want to run windows from R (in my experience it is much better
to reside entirely within R) then I think that you need to use Duncan Temple
Lang's RDCOM package ( http://www.omegahat.org/ ). It works well and
robustly for connections to other packages and I have tested it for Excel. 


Regards,


Gordon Morrison
Global Head of Quantitative Research

> * + 44 20 7653 7642
> Mob: + 44 7867 801951
> fax:  + 44 20 7645 7442
> * mailto:[EMAIL PROTECTED]
> web:  http://www.cbksec.com/rsh/portfolio&risk.html
> * Commerzbank Securities
>   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 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)

TIA
 (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] 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.


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 obvious manual,
I
would have thought).  If you are working on Windows, using RODBC is
perhaps the simplest.

-- 
Brian D. Ripley,  [EMAIL PROTECTED]
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel:  +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UKFax:  +44 1865 272595

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
 

Simon Fear
Senior Statistician
Syne qua non Ltd
Tel: +44 (0) 1379 69
Fax: +44 (0) 1379 65
email: [EMAIL PROTECTED]
web: http://www.synequanon.com
 
Number of attachments included with this message: 0
 
This message (and any associated files) is confidential and\ con...
{{dropped}}

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help


** 
This is a commercial communication from Commerzbank AG.

This communication is confidential and is intended only for the person to
whom it is addressed.  If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:[EMAIL PROTECTED]> immediately that you have
received it and then destroy the copy in your possession.

Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.

This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank.  Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

RE: [R] excel files and R

[Simon Fear]

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)

TIA
 (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] 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.


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 obvious manual,
I
would have thought).  If you are working on Windows, using RODBC is
perhaps the simplest.

-- 
Brian D. Ripley,  [EMAIL PROTECTED]
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel:  +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UKFax:  +44 1865 272595

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
 

Simon Fear
Senior Statistician
Syne qua non Ltd
Tel: +44 (0) 1379 69
Fax: +44 (0) 1379 65
email: [EMAIL PROTECTED]
web: http://www.synequanon.com
 
Number of attachments included with this message: 0
 
This message (and any associated files) is confidential and\ con... {{dropped}}

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

Re: [R] excel files and R

[Prof Brian Ripley]

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 obvious manual, I
would have thought).  If you are working on Windows, using RODBC is
perhaps the simplest.

-- 
Brian D. Ripley,  [EMAIL PROTECTED]
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel:  +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UKFax:  +44 1865 272595

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help

[R] excel files and R

[Victor H. Marím]

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 Ciencias Ecológicas, Fac. de Ciencias, 
Universidad de Chile
Casilla 653 Santiago, Chile
http://antar.uchile.cl
 

[[alternative HTML version deleted]]

__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help