Convenient export to Excel plugin?


#1

I wanted to gauge how many people are interested in having a convenient data.frame to Excel plugin?

I often have a need to load R data.frames into Excel but there is no convenient way to do it.

My current workflow is

  • fwrite(df, “file.csv”)
  • open “file.csv” in Excel

Or I would write to using an Excel package.

I want to gauge how much interest is there in a convenient to use load data.frame into Excel RStudio plugin, so you can just use a keyboard short-cut to bring up a search box, which shows you all the data.frames and you just choose one to export and it exports it to Excel and opens Excel for you.


#2

Interesting idea - my workflow is similar to yours, but it isn’t too burdensome; however, if a plugin existed, I’d give it a try.


#3

When I need to export to excel directly, I often use the openxlsx :package: with its write.xlsx function.
I then use shell.exec("myfile.xlsx") to say from R to open in windows the file with excel.

Sometimes, I use also csv format by writing them with readr::write_excel_csv2 and then open manually the file in excel.

I think if you do this kind of workflow a lot, using the addin feature of RStudio to hide your workflow behind a keyboard shortcut makes sense.

I find that snippet feature is also a convenient way to quickly achieve something - no keyboard shorcut but some keyword to write the chunk of code quickly seems to me similar and quicker to create.


#4

Wouldn’t be my cup of tea, per se (I’m terrible at Excel), but have you seen this?
http://bert-toolkit.com/


#5

It might be worth exploring whether an RStudio Addin could accomplish what you’re looking to do: https://rstudio.github.io/rstudioaddins/