[R] writing to an Excel file

[Prof Brian Ripley]

On Mon, 11 Apr 2005, Petr Pikal wrote:

> Hi Laura
>
> Pretty common question. You could find an answer going through
> archives.
> To copy to Excel through clipboard:
>
> write.excel<-function(tab, ...) write.table( tab, "clipboard",
> sep="\t", row.names=F)
>
> write.excel(your.data.frame)
>
> open Excel and press ctrl-C

Well, that is essentially

`writing to a regular data file and importing into Excel',

it just stores the data file on the clipboard.

Another way is to use RDCOM and Rexcel and drive this from Excel.  But 
that needs additional software installed.

>
> Cheers
> Petr
>
>
> On 10 Apr 2005 at 19:56, Laura Holt wrote:
>
>> Hi R!
>>
>> Is there a special function that writes data to an Excel file, please?
>>
>> I found read.spss and so on in the foreign library, but nothing to
>> write.
>>
>> Of course, writing to a regular data file and importing into Excel
>> works fine, but I thought that there might be another way.
>>
>> Thanks in advance.
>>
>> Sincerely,
>> Laura Holt
>> mailto: lauraholt_983 at hotmail.com
>> R Version 2.0.1 Windows
>>
>> ______________________________________________
>> R-help at 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
>
> Petr Pikal
> petr.pikal at precheza.cz
>
> ______________________________________________
> R-help at 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
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595