[R] RE:

[Yves Gauvreau]

> -----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 Federico Spinazzi
> Envoyé : Wednesday, December 06, 2000 9:59 AM
> À : r-help at stat.math.ethz.ch
> Objet : 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.

I would have tought that it was common knowledge that a file with a .csv
extention under windows, mean a file with comma separated values. Excel
knows how to handle many types of data files and a CSV file is just one of
these types.


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

The CSV extention would procure the same effect.

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

If you mean that using RODBC with standard Excel file would prevent you from
having pivot table and/or graphs and/or whatever other data structure Excel
can provide, in those same files then your wrong.

BTW you could also use RODBC directly with CSV files if you have the RODBC
text driver of course.

I hope this clarify both of our original message.

Regards

Yves Gauvreau

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

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