vxe-table 表格导出 csv 文件

导出时单元格类型默认是自动转换的，如果是需要字符串类型，可以通过 column.cell-type 设置

<template>
  <div>
    <vxe-button @click="exportEvent">直接导出 CSV 文件</vxe-button>
    <vxe-table
      show-footer
      ref="tableRef"
      :export-config="{}"
      :footer-data="footerData"
      :data="tableData">
      <vxe-column field="seq" type="seq" width="70"></vxe-column>
      <vxe-column field="name" title="Name"></vxe-column>
      <vxe-column field="sex" title="Sex"></vxe-column>
      <vxe-column field="no1" title="NO1"></vxe-column>
      <vxe-column field="no2" title="NO2" cell-type="string"></vxe-column>
    </vxe-table>
  </div>
</template>

<script>
export default {
  data () {

    const tableData = [
      { id: 10001, name: 'Test1', role: 'Develop', sex: 'Man', no1: '028', no2: '028' },
      { id: 10002, name: 'Test2', role: 'Test', sex: 'Women', no1: '220', no2: '220' },
      { id: 10003, name: 'Test3', role: 'PM', sex: 'Man', no1: '003200', no2: '003200' },
      { id: 10004, name: 'Test4', role: 'Designer', sex: 'Women', no1: '02040', no2: '02040' }
    ]

    const footerData = [
      { seq: '合计', sex: '666', age: '999' }
    ]

    return {
      tableData,
      footerData
    }
  },
  methods: {
    exportEvent () {
      const $table = this.$refs.tableRef
      if ($table) {
        $table.exportData({
          type: 'csv'
        })
      }
    }
  }
}
</script>