title: jQuery datatable export to Excel customization - Make first row bold
body: <p>I have a datatable with export to excel button I am trying to customize.
  I looked around to see how to customize and found a few but still having problem with this.</p>
  
  <p>When you export to excel the first row seems to be page title. I am trying to make this row bold; and if possible replace the text with something else other than the page title.</p>
  
  <p>Here is what I saw and tried to modify to achieve what I need:</p>
  
  <pre><code>buttons: [
  {
      extend: 'excelHtml5',
      customize: function ( xlsx ){
          var sheet = xlsx.xl.worksheets['sheet1.xml'];
  
          // jQuery selector to add a border
          //$('row c[r*="0"]', sheet).attr( 's', '25' );
          //$('row c[r^="C"]', sheet).attr( 's', '2' ); // third column is bold
  
          // Trying to make first row bold, this makes last row bold
          $('row c[r*="0"]', sheet).attr( 's', '2' );
          $(sheet.body)
              .css('font-size', '10pt');
  
          $(sheet.body).find('table')
              .addClass('compact')
              .css('font-size', 'inherit');
      },
      exportOptions: {
          columns: [0, 1, 2]
      },
  },
  </code></pre>
  
  <p>Also, when applying formatting it seems we use 'attr' with first parameter 's' and a number. How do I find out that 25 implies border and 2 implies bold?</p>
  
  <p>I don't understand how to manipulate the following to effect styling changes:</p>
  
  <pre><code>    $('row c[r*="0"]', sheet).attr( 's', '2' );
      $('row c[r^="C"]', sheet).attr( 's', '25' ); 
  </code></pre>