newToExcel.js 1.2 KB

12345678910111213141516171819202122232425262728293031323334
  1. // +----------------------------------------------------------------------
  2. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  3. // +----------------------------------------------------------------------
  4. // | Copyright (c) 2016~2021 https://www.crmeb.com All rights reserved.
  5. // +----------------------------------------------------------------------
  6. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  7. // +----------------------------------------------------------------------
  8. // | Author: CRMEB Team <admin@crmeb.com>
  9. // +----------------------------------------------------------------------
  10. import { export_json_to_excel } from '../vendor/Export2Excel';
  11. /**
  12. * @method exportExcel
  13. * @param {Array} header 表头
  14. * @param {Array} filterVal 表头属性字段
  15. * @param {String} filename 文件名称
  16. * @param {Array} tableData 列表数据
  17. **/
  18. export default function exportExcel(header, filterVal, filename, tableData) {
  19. var data = formatJson(filterVal, tableData);
  20. export_json_to_excel(
  21. header,
  22. data,
  23. filename
  24. );
  25. }
  26. function formatJson(filterVal, tableData) {
  27. return tableData.map(v => {
  28. return filterVal.map(j => {
  29. return v[j];
  30. });
  31. });
  32. }