vue导出excel表格（二）

秒速五厘米 2023-02-13 11:06 20阅读 0赞

## 1.安装插件 ##

cnpm install vue-json-excel

## 2.main.js中引入使用 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTIxNzU0MQ_size_16_color_FFFFFF_t_70]

import JsonExcel from 'vue-json-excel'
    Vue.component('downloadExcel', JsonExcel)

## 3.直接在页面中使用 ##

<download-excel
          class = "export-excel-wrapper"
          :data = "json_data"
          :fields = "json_fields"
          name = "远程诊断报告导出.xls">
          
          <el-button type="primary" size="small">导出EXCEL</el-button>
    </download-excel>

data() {
        return {
          json_fields: {
            "头部-诊断名称": "name",    //常规字段
            "头部-联系电话": "phone.mobile", //支持嵌套属性
            "头部-损坏区域代码": {
              field: "phone.landline",
                        //自定义回调函数
              callback: value => {
                return `损坏区域代码 - ${value}`;
              }
            }
          },
          json_data: [
            {
              name: "损坏的组件一",
              city: "New York",
              country: "United States",
              birthdate: "1978-03-15",
              phone: {
                mobile: "1-541-754-3010",
                landline: "(541) 754-3010"
              }
            },
            {
              name: "损坏的组件二",
              city: "Athens",
              country: "Greece",
              birthdate: "1987-11-23",
              phone: {
                mobile: "+1 855 275 5071",
                landline: "(2741) 2621-244"
              }
            }
          ],
          json_meta: [
            [
              {
                " key ": " charset ",
                " value ": " utf- 8 "
              }
            ]
          ]
        };
      }

**数据说明：**

*  json\_data: 需要导出的数据
 *  json\_fields:  
    自主选择要导出的字段，指定嵌套数据并将标签分配给键是标签的字段，值是JSON字段。这将“按原样”导出字段数据。如果需要自定义导出的数据，可以定义回调函数。里面的属性是excel表每一列的title,注意多个词组组成的属性名要加双引号

如果需要自定义导出的数据，可以定义回调函数。

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTIxNzU0MQ_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTIxNzU0MQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200528141142993.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTIxNzU0MQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTIxNzU0MQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200528141012700.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTIxNzU0MQ==,size_16,color_FFFFFF,t_70