title: How to convert html table to excel with multiple sheet?
body: <p>How can I convert multiple html tables to an excel sheet with multiple worksheets? Could you please help into this. </p>
  
  <p>My example <a href="https://jsfiddle.net/kdkd/5p22gdag/">https://jsfiddle.net/kdkd/5p22gdag/</a></p>
  
  <pre><code>        function tablesToExcel() {
          {
  
              var tab_text = "&lt;table border='2px'&gt;&lt;tr bgcolor='#87AFC6'&gt;";
              var textRange; var j = 0;
              tab = document.getElementById('tbl2'); // id of table
  
  
              for (j = 0 ; j &lt; tab.rows.length ; j++) {
                  tab_text = tab_text + tab.rows[j].innerHTML + "&lt;/tr&gt;";
                  //tab_text=tab_text+"&lt;/tr&gt;";
              }
  
              tab_text = tab_text + "&lt;/table&gt;";
              var ua = window.navigator.userAgent;
              var msie = ua.indexOf("MSIE ");
  
              if (msie &gt; 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer
              {
                  txtArea1.document.open("txt/html", "replace");
                  txtArea1.document.write(tab_text);
                  txtArea1.document.close();
                  txtArea1.focus();
                  sa = txtArea1.document.execCommand("SaveAs", true, "Say Thanks to Sumit.xls");
              }
              else                 //other browser not tested on IE 11
                  sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));
  
  
              return (sa);
          }
  
   }
  </code></pre>