Writing an Excel Readable File from R

Suppose you want to transfer the dataframe called data to Excel:

write.table(data,"clipboard",sep="\t",col.names=NA)

Then, in Excel, just type Ctrl+V or click on the Paste icon (the clipboard).

Get The R Book now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.