How to Easily Read and Write Data from Clipboard in R

Step 1. Copy the data from excel

Step 2. Import the data from the clipboard into R

my_data <- read_clip_tbl()
my_data

## # A tibble: 11 x 6
##   name                mpg   cyl  disp    hp  drat
##   <chr>             <dbl> <int> <dbl> <int> <dbl>
## 1 Mazda RX4          21       6   160   110  3.9 
## 2 Mazda RX4 Wag      21       6   160   110  3.9 
## 3 Datsun 710         22.8     4   108    93  3.85
## 4 Hornet 4 Drive     21.4     6   258   110  3.08
## 5 Hornet Sportabout  18.7     8   360   175  3.15
## 6 Valiant            18.1     6   225   105  2.76
## # … with 5 more rows

Write a data frame

1. Write the data to the clipboard:

write_clip(mtcars)

2. Paste the data into Excel: ctrl + c

Additional features

clipr returns the same object that was passed in.

res <- write_clip(c("Text", "for", "clipboard"))
res

## [1] "Text"      "for"       "clipboard"

To capture the string that clipr writes to the clipboard, specify return_new = TRUE. Character vectors with length > 1 will be collapsed with system-appropriate line breaks, unless otherwise specified

cb <- write_clip(c("Text", "for", "clipboard"), return_new = TRUE)
cb

## [1] "Text\nfor\nclipboard"

cb <- write_clip(c("Text", "for", "clipboard"), breaks = ", ", return_new = TRUE)
cb

## [1] "Text, for, clipboard"