Answers

• Brawl Posts: 2Questions: 1Answers: 0

  July 2022 edited July 2022

  As always, as soon as one asks a question, one finds an answer. Thank you anyway:

         $(document).ready(function () {
              $('#table_id').DataTable({
                  dom: 'Brtip',
                          {
              extend: 'excel',
        customize: function ( xlsx ) {
          var sheet = xlsx.xl.worksheets['sheet1.xml'];
          $('c[r=A1] t', sheet).text( 'Custom Heading in First Row' );
          $('row:first c', sheet).attr( 's', '2' ); // first row is bold
        }
      }                });
          });  
  
• rf1234 Posts: 2,991Questions: 87Answers: 421

  July 2022

  You could do this for example:

  <script>
      $(document).ready(function () {
          $('#table_id').DataTable({
              dom: 'Brtip',
              buttons: [
              'copy', 'csv', 
              { extend: "excel",
                 title:    function () { return "yourTitle" },
                 messageBottom: function () { return "yourMessageAtTheBottom" }
               }]
             });
         }); 
  </script>
  

  Here is another example also including messageTop.
  https://datatables.net/extensions/buttons/examples/html5/titleMessage.html