title: Exporting HTML tables to Excel (.xls) in a separate sheet
body: <p>I've got a simple HTML page (generated by an external application) that contains a table view.
  I am trying to scrape off the tables from the page and put them in an Excel workbook. 
  I have managed to put the whole HTML  contents in a workbook by using the method available <a href="https://stackoverflow.com/questions/6955627/export-dynamic-html-table-to-excel-in-javascript-in-firefox-browser">here</a>.</p>
  
  <p>Code from the related question:</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, name) {
      if (!table.nodeType) table = document.getElementById(table)
      var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
      window.location.href = uri + base64(format(template, ctx))
    }
  })()
  </code></pre>
  
  <ul>
  <li><a href="http://jsfiddle.net/insin/cmewv/" rel="nofollow noreferrer">JSFiddle </a></li>
  </ul>
  
  <p>The method however does not support multiple spreadsheets. What I need is for every HTML table being in it's own SpreadSheet in the same Excel workbook. Something like this:
  <img src="https://i.stack.imgur.com/XXDLW.png" alt="enter image description here"></p>
  
  <p>I have tried to create a sample Excel document with two spreadsheets and then reverse engineer it by looking at an export in .html format. Unfortunately I failed to understand how to recreate the connection betwee a workbook and it's sheets.</p>
  
  <p>As far as I can understand the <code>format()</code> function does the 'magical' combining of the worksheet data and the Excel template. The function looks very cryptic to me, so I have no idea how to go about modifying it.</p>
  
  <p>What I need as an end game is having the possibility to call something like.
  <code>tableToExcel(document.getElementsByTagName('table'), 'Workbook Name');</code></p>
  
  <p>Any ideas if this is at all possible, and if so -  how to go about making it happen?</p>