Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. <button onclick="exportToExcelRequest('tableExport')" class="btn btn-primary">Export Data To Excel File</button>
  2.  
  3. function exportToExcelRequest(tableID, filename = ''){
  4. var downloadurl;
  5. var dataFileType = 'application/vnd.ms-excel';
  6. var tableSelect = document.getElementById(tableID);
  7. var tableHTMLData = tableSelect.outerHTML.replace(/ /g, '%20');
  8.  
  9. filename = filename?filename+'.xls':'MarketOrderRequestReport.xls';
  10. downloadurl = document.createElement("a");
  11. document.body.appendChild(downloadurl);
  12. if(navigator.msSaveOrOpenBlob){
  13. var blob = new Blob(['ufeff', tableHTMLData], {
  14. type: dataFileType
  15. });
  16. navigator.msSaveOrOpenBlob(blob, filename);
  17. }else{
  18. downloadurl.href = 'data:' + dataFileType + ', '+ tableHTMLData;
  19. downloadurl.download = filename;
  20. downloadurl.click();
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement