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 644449 Fax: +44 (0) 1379 644445 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