Thursday, August 23, 2018

HTML to XLS export

 $("#export_xls").click(function(e){
    // alert('asdfasd');
    // $("#reports").table2excel({
    //   // exclude CSS class
    //   exclude: ".noExl",
    //   name: "Worksheet Name",
    //   filename: "SomeFile" //do not include extension
    // });
   // alert('hello');
    //getting values of current time for generating the file name
    var tab_text = '<html xmlns:x="urn:schemas-microsoft-com:office:excel">';
  tab_text = tab_text + '<head><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>';
  tab_text = tab_text + '<x:Name>Test Sheet</x:Name>';
  tab_text = tab_text + '<x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet>';
  tab_text = tab_text + '</x:ExcelWorksheets></x:ExcelWorkbook></xml></head><body>';
  tab_text = tab_text + "<table border='1px'>";
  var exportTable = $('#reports').clone();
  exportTable.find('input').each(function (index, elem) { $(elem).remove(); });
  tab_text = tab_text + exportTable.html();
  tab_text = tab_text + '</table></body></html>';
  var fileName = 'yearplanner_' + parseInt(Math.random() * 10000000000) + '.xls';

  //Save the file
  var blob = new Blob([tab_text], { type: "application/vnd.ms-excel;charset=utf-8" })
  window.saveAs(blob, fileName);
  /////////////////////////////
   
  });

0 comments:

Post a Comment