1、在Vue中导入、导出excel表格

1、安装

yarn add pikaz-excel-js

npm i -S pikaz-excel-js

2、导出

在页面中使用

<excel-export :sheet="sheet">
   <div>导出</div>
</excel-export>




   import {ExcelExport} from 'pikaz-excel-js'
  ...
  export default {
        components: {
            ExcelExport,
        },
        data () {
          return {
            sheet:[
              [
                title:"水果的味道",
                tHeader:["荔枝","柠檬"],
                table:[{litchi:"甜",lemon:"酸"}],
                keys:["litchi","lemon"],
                sheetName:"水果的味道",
              ]
            ]
          }
        }
  ...

3、导出

<excel-import :on-success="onSuccess">
   <div>导入</div>
</excel-import>



  import {ExcelImport} from 'pikaz-excel-js'
  ...
  export default {
        components: {
            ExcelImport,
        },
        methods:{
          onSuccess(data, file){
            console.log(data)
          }
        }
  ...

详细配置查看一个vue的excel导入导出插件，支持修改样式 - 掘金