newToExcel.js 1.2 KB

123456789101112131415161718192021222324252627282930
  1. // +----------------------------------------------------------------------
  2. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  3. // +----------------------------------------------------------------------
  4. // | Copyright (c) 2016~2023 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(header, data, filename);
  21. }
  22. function formatJson(filterVal, tableData) {
  23. return tableData.map((v) => {
  24. return filterVal.map((j) => {
  25. return v[j];
  26. });
  27. });
  28. }