title: How to export dataTable as Excel format?
body: <p>i have used tableTools plugins for Export datatable data, i have included following plugins</p>
  
  <pre><code>&lt;script src="js/jquery-1.12.3.js"&gt;&lt;/script&gt;
  &lt;script src="js/bootstrap.min.js"&gt;&lt;/script&gt;
  &lt;script src="js/moment/moment.min.js" type="text/javascript"&gt;&lt;/script&gt;
  &lt;script src="js/jquery.dataTables.js" type="text/javascript"&gt;&lt;/script&gt;
  &lt;script src="js/dataTables.tableTools.js"&gt;&lt;/script&gt;
  </code></pre>
  
  <p>HTML code</p>
  
  <pre><code>&lt;table id="result_table" class="display table table-bordered" cellspacing="0" width="100%"&gt;&lt;/table&gt;
  </code></pre>
  
  <p>and my Initialization part, </p>
  
  <pre><code>var oTable = $('#result_table').dataTable({
              //"iDisplayLength": 50,
              //"order" : [[0,"desc"]],
              "columnDefs": [
                  { "width": "16%", "targets": 1 }
                ],
              "lengthMenu": [[10, 50, 100, -1], [10, 50, 100, "All"]],
              "dom": 'T&lt;"clear"&gt;lfrtip',
              "tableTools": {
                  "sSwfPath": "copy_csv_xls_pdf.swf"
              }
          });
  </code></pre>
  
  <p>my actuall result is <a href="https://i.stack.imgur.com/cHGwY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cHGwY.png" alt="enter image description here"></a></p>
  
  <p>if i click Excel button my save as window is<a href="https://i.stack.imgur.com/kSCRl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kSCRl.png" alt="enter image description here"></a></p>
  
  <p>it was saved CSV file not as Xls or Xlsx format and also CSV button and Excel Button both are Export CSV file format only.. this is the problem i need to Export Excel format.. pls share your suggestion or solution</p>