Answers

• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  July 2023

  See if this thread helps to customize the header export.

  Kevin
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  July 2023

  Yes, a custom formatting function for the header is probably the best way to do it.

  However, if you need to based a calculation from the other rows in the table (your question makes it sound like you might was to sum the values?) then use customizeData from buttons.exportData() which lets you overwrite the values that have been read in.

  I can put an example of that together for you if you like. I'm just not clear on if you are doing a sum or not.

  Allan
• lisarush Posts: 85Questions: 15Answers: 0

  July 2023

  It looks like the example from the thread Kevin linked should help me. (I do not need to do a sum.)

  I essentially just want the Screen vs Export column to be formatted differently: in a nice human-readable form for the screen -- vs. a straight number for the export. This is easy to do for the column <td> value itself, via the orthogonal option and using, for example, data-sort on the <td> cell.

  Would it be possible to request that the orthogonal option also support using, for example, data-sort for the <th> cells, as well? That would be an easy and consistent way to do it...?
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  July 2023

  The orthogonal concept doesn't extend beyond the data in the table body at the moment. I'd need to have a think about how to introduce it beyond that, but you are right it might be sensible to do so. I need to have a think about what other areas it might be useful. It it is only export, then improving the formatting functions or perhaps introducing an orthogonal approach only there might be the way to do it.

  Let me know how you get on with!

  Allan
• lisarush Posts: 85Questions: 15Answers: 0

  July 2023

  I was able to implement this in a generic way for us. (We have an extension to dataTables, so that we can set & provide features, etc. in common across all tables.)

             exportOptions.format = {
                 header: function( html, colIdx, node ) {
                    if ( html &&  // found html text (will be empty if column header spans cols, so skip those)
                         node &&  // found element
                         node.dataset[exportOptions.exportDataType] ) {  // has 'data-' value set
                       return node.dataset[exportOptions.exportDataType];
                    } else {
                       return html;
                    }
                 }
              };
  

  Thanks for the starting help.
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  July 2023

  Very nice! Thanks for letting us know you've got it working as you need.

  Allan