print to console tables that can be easily copied and pasted to Excel

There is a function format_csv in package readr, which outputs csv formated output to string. It can be used as

to_console<-function(dta){
 cat(readr::format_csv(dta))
}


dta |> someoperation() |> to_console()
13 points · 2 comments · view on lemmy.world

2 Comments

morcution@lemmy.world · 4 pts · 3y (1 reply)

I use clipr::write_clip and clipr::read_clip - can paste to excel but also read in something you've copied from excel.

Helpful when you have a client with poorly formatted excel files, to the point that readxl won't do the job 😭

boredScientist@feddit.nl · 2 pts · 3y

Seconding clipr, it's my go-to for when i just need to quickly check or transferring something to and from Excel.