Complex headers export to Excel

Complex headers export to Excel

shankarastashankarasta Posts: 14Questions: 6Answers: 0

Hi Allan,

Is any new info on exporting complex headers to Excel?
If we still have to wait for V2, is there a work around?

Thanks,

Answers

  • allanallan Posts: 50,477Questions: 1Answers: 7,501 Site admin

    No - the is no workaround (other than adding the feature and submitting it as a pull request :)).

    Currently, yes, you need to wait until I get a chance to work on this.

    Allan

  • shankarastashankarasta Posts: 14Questions: 6Answers: 0

    Hi Allan,

    So I found the following changes made to the buttons plugin at
    https://github.com/rstudio/DT/issues/418

    I download his code and replaced button buttons.html5.min.js and dataTables.buttons.min.js.
    It works as desired and multi-level headers get exported correctly.

    Hope this helps, looks like an easy change until V2 comes out.

    Thanks,
    Shankar

  • allanallan Posts: 50,477Questions: 1Answers: 7,501 Site admin

    Awesome - thanks for posting that link.

    Allan

  • shankarastashankarasta Posts: 14Questions: 6Answers: 0

    Hi Allan,

    Any update on this issue?
    Is it still an open issue?

    Thanks,

  • allanallan Posts: 50,477Questions: 1Answers: 7,501 Site admin

    Correct, this is still an open issue. I've afraid I've not had a chance to work on this yet.

    Allan

  • einarameinaram Posts: 1Questions: 0Answers: 0

    I read about kind of a workaround that might help someone else.

    Merges the complex header to single line:

    http://jsfiddle.net/RajReddy/jzdjdo3z/21/

Sign In or Register to comment.