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

change col title only for some columns when export

change col title only for some columns when export

m75sam75sa Posts: 125Questions: 28Answers: 0
edited March 2022 in DataTables

Hi,
i know that there are several posts on the forum about this but no result i had sorry.
I have a table with 3 columns. I would like to change only the second column title (for example) when i export via 'export button'

Any ideas?

This question has an accepted answers - jump to answer

Answers

  • rf1234rf1234 Posts: 2,809Questions: 85Answers: 406
    edited March 2022 Answer ✓ 
    buttons: [
{ extend: "excel",
    customize: function( xlsx ) {
        var sheet = xlsx.xl.worksheets['sheet1.xml'];
        $('row:eq(0) c[r^="B"] t', sheet).text("newColumnName");
    }
} ]
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.