R: [R] RE:

Federico Spinazzi spinazzi at databankgroup.it
Wed Dec 6 15:59:18 CET 2000


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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list