R: [R] RE:
A trick I use is to give tab-delimited text files created by excel or R the .xls extension: this may apply, and it may be better, to CSV: R couldn't see any difference whichever the extension will be, and windows will be foolished by the .xls extension an will open the file with Excel that will handel it CORRECTLY. If you need to have the data always alligned in Excel and R this trick will allow to bypass the manual operation of a "Save As" dialog. Another option could be to use RODBC with a datasource set to an Excel File: as you see tha above trick don't scale well as you can have your own graphs an pivot tables in the excel file and you cannot susbtitute this with a text file. Hope that helps. Federico Spinazzi spinazzi at databankgroup.it Databank S.P.A Via Spartaco, 19, ITALY Tel. + 39 02 55002251 -----Messaggio originale----- Da: Yves Gauvreau <cyg at sympatico.ca> A: HAKIM Nour-Eddine <noureddine.hakim at axa-corporatesolutions.com>; R-help at r-project.org <R-help at r-project.org> Data: mercoled? 6 dicembre 2000 14.14 Oggetto: [R] RE:
From Excel save your data as a *.csv and then use "read.csv" to read it in
R
workspace. YG -----Message d'origine----- De : owner-r-help at stat.math.ethz.ch [mailto:owner-r-help at stat.math.ethz.ch]De la part de HAKIM Nour-Eddine Envoy? : Wednesday, December 06, 2000 6:03 AM ? : 'R-help at r-project.org' Objet : Dear , I want to import Excel data (.XLS). Can you help me to this. Best regards. Nour-Eddine HAKIM -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
.
-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
.
_._ -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
._._ -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._