DT icon indicating copy to clipboard operation
DT copied to clipboard

One extra insert with DT::datatable extensions download excel button

Open D-Harouni opened this issue 2 years ago • 1 comments

While using the extension download buttons in DT::data table (specifically excel sheets), the output includes an extra title column with the name of the Button or similar, is there any way to remove the newly inserted row ?

This is an example

data %>%
DT::datatable(extensions = 'Buttons', options = list(dom = 'Blfrtip', buttons = c('excel'), lengthMenu = list(c(5,25,50,-1), c(10,25,50,"All"))))


By filing an issue to this repo, I promise that

  • [X] I have fully read the issue guide at https://yihui.name/issue/.
  • [X] I have provided the necessary information about my issue.
    • If I'm asking a question, I have already asked it on Stack Overflow or RStudio Community, waited for at least 24 hours, and included a link to my question there.
    • If I'm filing a bug report, I have included a minimal, self-contained, and reproducible example, and have also included xfun::session_info('DT'). I have upgraded all my packages to their latest versions (e.g., R, RStudio, and R packages), and also tried the development version: remotes::install_github('rstudio/DT').
    • If I have posted the same issue elsewhere, I have also mentioned it in this issue.
  • [X] I have learned the Github Markdown syntax, and formatted my issue correctly.

I understand that my issue may be closed if I don't fulfill my promises.

D-Harouni avatar Oct 14 '21 14:10 D-Harouni

See https://stackoverflow.com/questions/58735095/remove-title-row-above-header-in-shiny-datatable-excel-output/58735938#58735938

stla avatar Oct 14 '21 17:10 stla