Vxe UI vue vxe-table 虚拟树表格的使用,流畅的渲染万级数据树结构表格
代码
普通树表格,一般存数据库里都是平级数据,vxe-table 的树渲染这就非常友好了,只有带有父子id关联的数组,就可以自动渲染树表格。
<template>
<div>
<vxe-grid v-bind="gridOptions"></vxe-grid>
</div>
</template>
<script setup>
import { reactive } from 'vue'
const gridOptions = reactive({
border: true,
treeConfig: {
transform: true, // 开启自动转换,如果为 false 则需要传带有 children 的树结构
rowField: 'id', // 行 key
parentField: 'parentId' // 父级行 key
},
columns: [
{ type: 'seq', width: 70 },
{ field: 'name', title: 'Name', minWidth: 300, treeNode: true },
{ field: 'size', title: 'Size' },
{ field: 'type', title: 'Type' },
{ field: 'date', title: 'Date' }
],
data: [
{ id: 10000, parentId: null, name: 'Test1', type: 'mp3', size: 1024, date: '2020-08-01' },
{ id: 10050, parentId: null, name: 'Test2', type: 'mp4', size: 0, date: '2021-04-01' },
{ id: 24300, parentId: 10050, name: 'Test3', type: 'avi', size: 1024, date: '2020-03-01' },
{ id: 20045, parentId: 24300, name: 'Test4', type: 'html', size: 600, date: '2021-04-01' },
{ id: 10053, parentId: 24300, name: 'Test5', type: 'avi', size: 0, date: '2021-04-01' },
{ id: 24330, parentId: 10053, name: 'Test6', type: 'txt', size: 25, date: '2021-10-01' },
{ id: 21011, parentId: 10053, name: 'Test7', type: 'pdf', size: 512, date: '2020-01-01' },
{ id: 22200, parentId: 10053, name: 'Test8', type: 'js', size: 1024, date: '2021-06-01' },
{ id: 23666, parentId: null, name: 'Test9', type: 'xlsx', size: 2048, date: '2020-11-01' },
{ id: 23677, parentId: 23666, name: 'Test10', type: 'js', size: 1024, date: '2021-06-01' },
{ id: 23671, parentId: 23677, name: 'Test11', type: 'js', size: 1024, date: '2021-06-01' },
{ id: 23672, parentId: 23677, name: 'Test12', type: 'js', size: 1024, date: '2021-06-01' },
{ id: 23688, parentId: 23666, name: 'Test13', type: 'js', size: 1024, date: '2021-06-01' },
{ id: 23681, parentId: 23688, name: 'Test14', type: 'js', size: 1024, date: '2021-06-01' },
{ id: 23682, parentId: 23688, name: 'Test15', type: 'js', size: 1024, date: '2021-06-01' },
{ id: 24555, parentId: null, name: 'Test16', type: 'avi', size: 224, date: '2020-10-01' },
{ id: 24566, parentId: 24555, name: 'Test17', type: 'js', size: 1024, date: '2021-06-01' },
{ id: 24577, parentId: 24555, name: 'Test18', type: 'js', size: 1024, date: '2021-06-01' }
]
})
</script>
虚拟树表格
这是一个几千节点的树结构
树结构几千节点和20列,渲染后操作非常流畅
不管是单个展开还是全部展开,操作都非常流畅
<template>
<div>
<div>
<vxe-button @click="expandAllEvent">展开所有</vxe-button>
<vxe-button @click="clearExpandEvent">收起所有</vxe-button>
</div>
<vxe-grid ref="gridRef" v-bind="gridOptions"></vxe-grid>
</div>
</template>
<script setup>
import { ref, reactive } from 'vue'
const gridRef = ref()
const gridOptions = reactive({
border: true,
showOverflow: true,
height: 800,
loading: false,
treeConfig: {
transform: true
},
scrollY: {
enabled: true,
gt: 0
},
columns: [
{ type: 'checkbox', width: 60 },
{ type: 'seq', width: 300, treeNode: true },
{ field: 'id', title: 'Id' },
{ field: 'name', title: 'Name' }
],
data: []
})
const loadList = () => {
gridOptions.loading = true
fetch('/resource/json/provinces_list.json').then(res => res.json()).then((data) => {
gridOptions.data = data
gridOptions.loading = false
})
}
const expandAllEvent = () => {
const $grid = gridRef.value
if ($grid) {
$grid.setAllTreeExpand(true)
}
}
const clearExpandEvent = () => {
const $grid = gridRef.value
if ($grid) {
$grid.clearTreeExpand()
}
}
loadList()
</script>