title: how to hide 3rd row from table while exporting to excel?
body: <p>i have a jquery code to export into excel from html table but it is leaving one blank row while exporting, i am using bootstrap for table designing, how to remove this blank row while exporting into excel. i got the code form <a href="https://gist.github.com/insin/1031969" rel="nofollow">here</a></p>
  
  <p>my php/table code is-<br/></p>
  
  <pre><code>&lt;table id="empTable" class="table table-striped table-bordered" cellspacing="0" border="1"&gt;
      &lt;thead class="table-th"&gt;
          &lt;tr valign="middle"&gt;
              &lt;th&gt;SN&lt;/th&gt;
              &lt;th&gt;Employee Name&lt;/th&gt;                
              &lt;th&gt;DOB&lt;/th&gt;
              &lt;th&gt;City&lt;/th&gt;            
          &lt;/tr&gt;
      &lt;/thead&gt;
      &lt;tbody&gt;                           
              &lt;?php 
              $count = 0;            
              foreach ($record as $key =&gt; $data) { $count+=1; 
              $employee_name=$data['employee_name'];
              $city=$data['city'];
              $dob=$data['dob'];                         
              echo "&lt;tr&gt;";                
              echo "&lt;td&gt;".$count."&lt;/td&gt;";                
              echo "&lt;td&gt;".$employee_name."&lt;/td&gt;";
              echo "&lt;td&gt;".$dob."&lt;/td&gt;";
              echo "&lt;td&gt;".$city."&lt;/td&gt;";           
              echo "&lt;/tr&gt;";
              ?&gt;                
          &lt;?php } ?&gt; 
      &lt;/tbody&gt;
      &lt;tfoot class="table-tf"&gt;  
          &lt;tr&gt;&lt;td colspan="4"&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;
      &lt;/tfoot&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>and my js code is-</p>
  
  <pre><code>var tableToExcel = (function() {
    var uri = 'data:application/vnd.ms-excel;base64,'
      , template = '&lt;html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"&gt;&lt;head&gt;&lt;!--[if gte mso 9]&gt;&lt;xml&gt;&lt;x:ExcelWorkbook&gt;&lt;x:ExcelWorksheets&gt;&lt;x:ExcelWorksheet&gt;&lt;x:Name&gt;{worksheet}&lt;/x:Name&gt;&lt;x:WorksheetOptions&gt;&lt;x:DisplayGridlines/&gt;&lt;/x:WorksheetOptions&gt;&lt;/x:ExcelWorksheet&gt;&lt;/x:ExcelWorksheets&gt;&lt;/x:ExcelWorkbook&gt;&lt;/xml&gt;&lt;![endif]--&gt;&lt;/head&gt;&lt;body&gt;&lt;table&gt;{table}&lt;/table&gt;&lt;/body&gt;&lt;/html&gt;'
      , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
      , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
    return function(table,table_title ,name) {
      if (!table.nodeType) table = document.getElementById(table)
      var ctx = {worksheet: name || 'Worksheet', table: '&lt;center&gt;&lt;b&gt;'+table_title+'&lt;/b&gt;&lt;/center&gt;&lt;br/&gt;'+table.innerHTML}
      window.location.href = uri + base64(format(template, ctx))
    }
  })()
  </code></pre>
  
  <p><br/> and my output is-<br/></p>
  
  <pre><code>Employee Detail         
  SN  Employee Name   DOB City
  
  1   John    12-18-1983  Texas
  2   Sarah   08-26-1985  CA
  3   David   06-15-1986  HX
  4   Nick    06-14-1982  Miami
  </code></pre>