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: [EMAIL PROTECTED] R Version 2.0.1 Windows
______________________________________________ [email protected] 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 [EMAIL PROTECTED]
______________________________________________ [email protected] 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, [EMAIL PROTECTED] 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
______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
