RE: [R] excel files and R

2003-06-25 Thread Simon Fear
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

RE: [R] excel files and R

2003-06-25 Thread Morrison, Gordon
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

RE: [R] excel files and R

2003-06-25 Thread Prof Brian Ripley
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

RE: [R] excel files and R

2003-06-25 Thread Pfaff, Bernhard
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

Re: [R] excel files and R

2003-06-25 Thread 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

Re: [R] excel files and R

2003-06-25 Thread 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

RE: [R] excel files and R

2003-06-25 Thread Simon Fear
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

RE: [R] excel files and R

2003-06-25 Thread 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

RE: [R] excel files and R

2003-06-25 Thread 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

RE: [R] excel files and R

2003-06-25 Thread partha_bagchi
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

Re: [R] excel files and R

2003-06-25 Thread 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

RE: [R] excel files and R

2003-06-25 Thread 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 -

Re: [R] excel files and R

2003-06-25 Thread 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

RE: [R] excel files and R

2003-06-25 Thread Norm Phillips
) -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

Re: [R] excel files and R

2003-06-25 Thread 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