Unable to have Complex headers export to Excel and csv

[Rohit1310]

I have been trying to export the datatable using the Button extention of DT with a complex header for example as below:

but I am getting only the last row in the header as below when exporting the datatable

I have searched alot but didn't got any satisfactory outcome.
I know this can be achieved using jquery but can you help me with some function in r.

Kindly help me to fix this issue.

By filing an issue to this repo, I promise that

• I have fully read the issue guide at https://yihui.name/issue/.
• 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.
• 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.

[stla]

Hello,

Not possible with datatables. You can use the TableExport library; see https://stackoverflow.com/questions/41966732/r-datatable-buttons-export-with-formated-cells/54350639#54350639.

[shrektan]

It will be possible after @mtyszler 's PR being merged to the upstream, i.e., the DataTables's Button extension. See the comment in PR #751 .

[shrektan]

Close this for now as it's duplicated with #418 .

[mtyszler]

Dear @Rohit1310

Feel free to check my fork at https://github.com/mtyszler/DT/tree/feature/complex_headers

This fork is up-to-date with https://github.com/rstudio/DT master plus my complex_headers treatment.

You can fork it yourself or simply install using remotes::install_github('mtyszler/DT', ref = "feature/complex_headers")

If you prefer to copy, you only need:

• dataTables.buttons.min.js
• buttons.html5.min.js
• buttons.print.min.js

which can be found at: https://github.com/mtyszler/DT/tree/feature/complex_headers/inst/htmlwidgets/lib/datatables-extensions/Buttons/js

[mtyszler]

Also, @Rohit1310 , just be aware that the version I provided in DataTables/Buttons#170 is more complete, as it also handles complex footers, and the merges for pdf and print.

But for excel and csv export this will suffice.

[Rohit1310]

Thanks @mtyszler for addressing the issue.