R: [R] RE:

About this list Date view Thread view Subject view Author view Other groups

Subject: R: [R] RE:
From: Federico Spinazzi (spinazzi@databankgroup.it)
Date: Thu 07 Dec 2000 - 00:59:18 EST 

Message-ID: <000a01c05f95$1ff74b00$0a00a8c0@bellview>

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@databankgroup.it
Databank S.P.A
Via Spartaco, 19, ITALY
Tel. + 39 02 55002251

-----Messaggio originale-----
Da: Yves Gauvreau <cyg@sympatico.ca>
A: HAKIM Nour-Eddine <noureddine.hakim@axa-corporatesolutions.com>;
R-help@r-project.org <R-help@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@stat.math.ethz.ch
>[mailto:owner-r-help@stat.math.ethz.ch]De la part de HAKIM Nour-Eddine
>Envoyé : Wednesday, December 06, 2000 6:03 AM
>À : 'R-help@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@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@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@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

About this list Date view Thread view Subject view Author view Other groups

This archive was generated by hypermail 2b25 : Thu 01 Feb 2001 - 16:14:35 EST