Re: [R] Handling of tables in R

From: Romain Francois <francoisromain_at_free.fr>
Date: Fri 19 Aug 2005 - 19:37:01 EST

Le 19.08.2005 11:22, Anne a écrit :

>Save your table in a text file ( see ?write.table ) with the separator
>set to "\t" ; you can then import it into excel
>
>for the nb of digits use
>
>
>>options(digits=3)
>>
>>
>
>see ?options
>
>
>
Hello,

And if you run R on windows (just a guess because you didn't tell), the saving-to-a-file part is not necessary. use : R> write.table(your.data.frame, file='clipboard') and on excel "paste", your data should magically appear on excel ...

Romain

>Anne
>
>
>2005/8/19, Fredrik Thuring <frt@codan.dk>:
>
>
>> Hi!
>>
>> I have a few questions concerning reading of tables from R to
>>other programs. My main question is if it's even possible to read a table
>>created in R (with the functions data.frame and save) to Excel (or
>>maybe SAS) and if so how does one do this? If I just mark the table in R
>>and copy-paste to Excel the whole table ends up in one single cell, (of
>>course). My goal is to copy the table to Excel (or SAS) in such a
>>way that a single observation gets placed in a single cell.
>>
>> If this isn't possible, is there any way to reduce the number of
>>digits in a table in R?
>>
>> I would be more than happy if there were any one who knows the
>>answer to my questions!
>>
>> Thanks before hand,
>> Fredrik Thuring
>> Research department
>> Codan Insurance, Copenhagen
>>
>>

-- 
visit the R Graph Gallery : http://addictedtor.free.fr/graphiques
~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~
~~~~~~      Romain FRANCOIS - http://addictedtor.free.fr         ~~~~~~
~~~~        Etudiant  ISUP - CS3 - Industrie et Services           ~~~~
~~                http://www.isup.cicrp.jussieu.fr/                  ~~
~~~~           Stagiaire INRIA Futurs - Equipe SELECT              ~~~~
~~~~~~   http://www.inria.fr/recherche/equipes/select.fr.html    ~~~~~~
~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Fri Aug 19 19:41:10 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:39:54 EST