title: Make the Title row in grey background with Blue fonts after convert json to excel
body: <p>I have developed a json to csv file download function everything works fine but I'm not sure how to make the first row of the table which are &quot;Vehicle, Date, Location, Speed&quot; background color in lightgrey and font in blue and always expand the columns upon opening the file</p>
  <p>Here is the fiddle <a href="http://jsfiddle.net/harvindr/v5cw94u8/1/" rel="nofollow noreferrer">http://jsfiddle.net/harvindr/v5cw94u8/1/</a></p>
  <pre><code>function JSONToCSVConvertor(JSONData, ReportTitle, ShowLabel) {
      //If JSONData is not an object then JSON.parse will parse the JSON string in an Object
      var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;
      
      var CSV = '';    
      //Set Report title in first row or line
      
      CSV += ReportTitle + '\r\n\n';
  
      //This condition will generate the Label/Header
      if (ShowLabel) {
          var row = &quot;&quot;;
          
          //This loop will extract the label from 1st index of on array
          for (var index in arrData[0]) {
              
              //Now convert each value to string and comma-seprated
              row += index + ',';
          }
  
          row = row.slice(0, -1);
          
          //append Label row with line break
          CSV += row + '\r\n';
      }
      
      //1st loop is to extract each row
      for (var i = 0; i &lt; arrData.length; i++) {
          var row = &quot;&quot;;
          
          //2nd loop will extract each column and convert it in string comma-seprated
          for (var index in arrData[i]) {
              row += '&quot;' + arrData[i][index] + '&quot;,';
          }
  
          row.slice(0, row.length - 1);
          
          //add a line break after each row
          CSV += row + '\r\n';
      }
  
      if (CSV == '') {        
          alert(&quot;Invalid data&quot;);
          return;
      }   
      
      //Generate a file name
     // var fileName = &quot;MyReport_&quot;;
      //this will remove the blank-spaces from the title and replace it with an underscore
     // fileName += ReportTitle.replace(/ /g,&quot;_&quot;);   
      
      //Initialize file format you want csv or xls
      var uri = 'data:text/csv;charset=utf-8,' + escape(CSV);
      
      // Now the little tricky part.
      // you can use either&gt;&gt; window.open(uri);
      // but this will not work in some browsers
      // or you will not get the correct file extension    
      
      //this trick will generate a temp &lt;a /&gt; tag
      var link = document.createElement(&quot;a&quot;);    
      link.href = uri;
      
      //set the visibility hidden so it will not effect on your web-layout
      link.style = &quot;visibility:hidden&quot;;
      link.download = &quot;PrognosData.csv&quot;;
      
      //this part will append the anchor tag and remove it after automatic click
      document.body.appendChild(link);
      link.click();
      document.body.removeChild(link);
  }
  </code></pre>