R markdown: download a html table to an excel file

Question

I have a R markdown where I built a table and I want to add the option to download the table to a excel file.

kable(MyTable) %>%
  kable_styling(bootstrap_options = c("striped", "hover", "condensed", 
  "responsive")) %>%
  scroll_box(width = "900px", height = "500px")

Your question is not about `knitr` or `kableExtra`, it's about `shiny` and handling file downloads. Take a look at [`shiny::downloadHandler`](https://shiny.rstudio.com/gallery/download-file.html). — r2evans, Dec 11 '18 at 16:30
The point is that we do not want to use a shiny app but a r markdown html — JuanFerrer, Dec 13 '18 at 15:43

score 9 · Accepted Answer · answered Dec 11 '18 at 16:56

9

You could always try using DT::datatable to get export buttons

MyTable %>%
  DT::datatable(
    extensions = 'Buttons', 
    options = list(dom = 'Bfrtip', 
                   buttons = c('excel', "csv")))

answered Dec 11 '18 at 16:56

Ross Dahlke

149
3

small remark,specifying which buttons should appear seems to require a list, not a vector: `..., buttons = list("excel", "csv")` – Mark Heckmann Mar 25 '19 at 13:53
2

I got a CSV button only, and nothing happens when I click it. – abalter May 09 '19 at 04:29

R markdown: download a html table to an excel file

1 Answers1