Copy a data frame to clipboard for pasting in Excel

This is a pipe-optimised function, and accompanies read_df() as a tool for ad-hoc analysis, which reads a data table copied from Excel into R.

copy_df(
  x,
  row.names = FALSE,
  col.names = TRUE,
  expand = "",
  quietly = FALSE,
  ...
)

Arguments

x

Data frame to be passed through. Cannot contain list-columns or nested data frames.

row.names

A logical vector for specifying whether to allow row names. Defaults to FALSE.

col.names

A logical vector for specifying whether to allow column names. Defaults to FALSE.

expand

Add number to manually expand clipboard size

quietly

Set this to TRUE to not print data frame on console

...

Additional arguments for write.table().