export.js 1.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. // 将一个sheet转成最终的excel文件的blob对象,然后利用URL.createObjectURL下载
  2. function sheet2blob(sheet, sheetName) {
  3. sheetName = sheetName || 'sheet1';
  4. var workbook = {
  5. SheetNames: [sheetName],
  6. Sheets: {}
  7. };
  8. workbook.Sheets[sheetName] = sheet; // 生成excel的配置项
  9. var wopts = {
  10. bookType: 'xlsx', // 要生成的文件类型
  11. bookSST: false, // 是否生成Shared String Table,官方解释是,如果开启生成速度会下降,但在低版本IOS设备上有更好的兼容性
  12. type: 'binary'
  13. };
  14. var wbout = XLSX.write(workbook, wopts);
  15. var blob = window.URL.createObjectURL(new Blob([s2ab(wbout)], {
  16. type: "application/octet-stream"
  17. }))
  18. // new Blob([s2ab(wbout)], {
  19. // type: "application/octet-stream"
  20. // }); // 字符串转ArrayBuffer
  21. function s2ab(s) {
  22. var buf = new ArrayBuffer(s.length);
  23. var view = new Uint8Array(buf);
  24. for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;
  25. return buf;
  26. }
  27. return blob;
  28. }
  29. function openDownloadDialog(url, saveName) {
  30. if (typeof url == 'object' && url instanceof Blob) {
  31. url = URL.createObjectURL(url); // 创建blob地址
  32. }
  33. var aLink = document.createElement('a');
  34. aLink.href = url;
  35. aLink.download = saveName || ''; // HTML5新增的属性,指定保存文件名,可以不要后缀,注意,file:///模式下不会生效
  36. var event;
  37. if (window.MouseEvent) event = new MouseEvent('click');
  38. else {
  39. event = document.createEvent('MouseEvents');
  40. event.initMouseEvent('click', true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null);
  41. }
  42. aLink.dispatchEvent(event);
  43. }