DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

How can i make row header in excel while export?

How can i make row header in excel while export?

hasibhasib Posts: 1Questions: 1Answers: 0
in Free community support

I am trying to export as excel from table. but the header will be in the row . Like the screenshot. I want to keep the row header and data on the right. How can i do that, I have tried many example but not work. Help me please. Thanks

Answers

  • allanallan Posts: 63,427Questions: 1Answers: 10,456 Site admin

    There is no "pivot" option like that in DataTables I'm afraid. You would need to either modify the export that Buttons does or write your own XLS exporter using SheetJS or similar.

    Allan

Sign In or Register to comment.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.