utils_excel.js 835 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
const data = {
  exportToExcel(columnList = [], dataList = [], fileName = 'data') {
    const tHeader = []
    const filterVal = []
    for (const item of columnList) {
      const jtem = item.split('=')
      tHeader.push(jtem[0])
      filterVal.push(jtem[1])
    }
    require.ensure([], () => {
      const { export_json_to_excel } = require('./Export2Excel.js')
      const data = this.formatJson(filterVal, dataList)
      export_json_to_excel(tHeader, data, fileName)
    })
  },
  formatJson(filterVal, jsonData) {
    return jsonData.map(v => filterVal.map(j => v[j]))
  },
  exportJsonToExcelMuilt(dataList = [], fileName = 'data') {
    require.ensure([], () => {
      const { export_json_to_excel_muilt } = require('./Export2Excel.js')
      export_json_to_excel_muilt(dataList, fileName)
    })
  }
}
export default data