Handling of tables in R

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 

 

Anne


2005/8/19, Fredrik Thuring <frt at 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