导入导出

<!-- 导入需要的包 （一定要放到index.html中的head标签里）-->
<script src="https://cdn.staticfile.net/FileSaver.js/2014-11-29/FileSaver.min.js"></script>
<script src="https://cdn.staticfile.net/xlsx/0.18.2/xlsx.full.min.js"></script>

表格导出

效果预览可直接操作下方示例

excelBtn设置为true即可开启导出功能

正在加载示例…

<template>
  <avue-crud :option="option"
             :data="data"></avue-crud>
</template>

<script setup>
import { ref } from 'vue';

const data = ref([
  {
    text1: '内容1-1',
    text2: '内容1-2',
    deep: {
      text3: '内容1-3',
    },
  },
  {
    text1: '内容2-1',
    text2: '内容2-2',
    deep: {
      text3: '内容2-3',
    },
  },
]);

const option = ref({
  excelBtn: true,
  column: [
    {
      label: '列内容1',
      prop: 'text1',
    },
    {
      label: '列内容2',
      prop: 'text2',
    },
    {
      label: '列内容3',
      prop: 'text3',
      bind: 'deep.text3',
    },
  ],
});
</script>

表格导入

效果预览可直接操作下方示例

正在加载示例…

<template>
  <div style="display:flex;">
    <el-button type="primary"
               @click="handleGet">下载模版</el-button>
    &nbsp;&nbsp;
    <el-upload :auto-upload="false"
               :show-file-list="false"
               action="action"
               :on-change="handleChange">
      <el-button type="primary">导入 excel</el-button>
    </el-upload>
  </div>
  <br />
  <avue-crud :option="option"
             :data="data"></avue-crud>
</template>

<script setup>
import { ref, getCurrentInstance } from 'vue';
let { proxy } = getCurrentInstance()
const data = ref([]);
const option = ref({
  column: [
    { label: 'id', prop: 'id' },
    { label: '姓名', prop: 'name' },
    { label: '年龄', prop: 'sex' },
  ],
});

function handleGet () {
  window.open('/cdn/demo.xlsx');
}

function handleChange (file, fileList) {
  proxy.$Export.xlsx(file.raw).then((data) => {
    data.value = data.results;
  });
}
</script>