推薦 vue2、vue3 中功能最強大的表格元件，效能最強大的表格元件推薦、可編輯表格推薦

可不简单發表於2024-11-21

vxe-table 是一個vue的表格元件，支援可編輯和虛擬滾動高效能表格，公司使用了幾年的表格，grid 渲染器擴充套件功能非常強大。

npm install vxe-pc-ui@4.3.2 vxe-table@4.9.3

// ...
import VxeUI from 'vxe-pc-ui'
import 'vxe-pc-ui/lib/style.css'
import VxeUITable from 'vxe-table'
import 'vxe-table/lib/style.css'
// ...

createApp(App).use(VxeUI).use(VxeUITable).mount('#app')
// ...

基礎使用

<template>
  <div>
    <vxe-table
      :data="tableData">
      <vxe-column 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="age" title="Age"></vxe-column>
    </vxe-table>
  </div>
</template>

<script>
export default {
  data () {
    const tableData = [
      { id: 10001, name: 'Test1', role: 'Develop', sex: 'Man', age: 28, address: 'test abc' },
      { id: 10002, name: 'Test2', role: 'Test', sex: 'Women', age: 22, address: 'Guangzhou' },
      { id: 10003, name: 'Test3', role: 'PM', sex: 'Man', age: 32, address: 'Shanghai' },
      { id: 10004, name: 'Test4', role: 'Designer', sex: 'Women', age: 24, address: 'Shanghai' }
    ]
    return {
      tableData
    }
  }
}
</script>

多選

單選

單元格合併

標題字首提示

凍結列

樹表格

<template>
  <div>
    <vxe-grid v-bind="gridOptions"></vxe-grid>
  </div>
</template>

<script>
export default {
  data () {
    const gridOptions = {
      border: true,
      treeConfig: {
        rowField: 'id',
        childrenField: 'children'
      },
      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, name: 'Test1', type: 'mp3', size: 1024, date: '2020-08-01' },
        {
          id: 10050,
          name: 'Test2',
          type: 'mp4',
          size: 0,
          date: '2021-04-01',
          children: [
            {
              id: 24300,
              name: 'Test3',
              type: 'avi',
              size: 1024,
              date: '2020-03-01',
              children: [
                { id: 20045, name: 'Test4', type: 'html', size: 600, date: '2021-04-01' },
                {
                  id: 10053,
                  name: 'Test5',
                  type: 'avi',
                  size: 0,
                  date: '2021-04-01',
                  children: [
                    { id: 24330, name: 'Test6', type: 'txt', size: 25, date: '2021-10-01' },
                    { id: 21011, name: 'Test7', type: 'pdf', size: 512, date: '2020-01-01' },
                    { id: 22200, name: 'Test8', type: 'js', size: 1024, date: '2021-06-01' }
                  ]
                }
              ]
            }
          ]
        },
        {
          id: 23666,
          name: 'Test9',
          type: 'xlsx',
          size: 2048,
          date: '2020-11-01',
          children: [
            {
              id: 23677,
              name: 'Test10',
              type: 'js',
              size: 1024,
              date: '2021-06-01',
              children: [
                { id: 23671, name: 'Test11', type: 'js', size: 1024, date: '2021-06-01' },
                { id: 23672, name: 'Test12', type: 'js', size: 1024, date: '2021-06-01' }
              ]
            },
            {
              id: 23688,
              name: 'Test13',
              type: 'js',
              size: 1024,
              date: '2021-06-01',
              children: [
                { id: 23681, name: 'Test14', type: 'js', size: 1024, date: '2021-06-01' },
                { id: 23682, name: 'Test15', type: 'js', size: 1024, date: '2021-06-01' }
              ]
            }
          ]
        },
        {
          id: 24555,
          name: 'Test16',
          type: 'avi',
          size: 224,
          date: '2020-10-01',
          children: [
            { id: 24566, name: 'Test17', type: 'js', size: 1024, date: '2021-06-01' },
            { id: 24577, name: 'Test18', type: 'js', size: 1024, date: '2021-06-01' }
          ]
        }
      ]
    }
    return {
      gridOptions
    }
  }
}
</script>

行與列拖拽調整順序

<template>
  <div>
    <vxe-button status="success" @click="resultEvent">獲取資料</vxe-button>
    <vxe-grid ref="gridRef" v-bind="gridOptions"></vxe-grid>
  </div>
</template>

<script>
export default {
  data () {
    const gridOptions = {
      border: true,
      columnConfig: {
        useKey: true,
        drag: true
      },
      rowConfig: {
        useKey: true,
        drag: true
      },
      columns: [
        { field: 'name', title: 'Name' },
        { field: 'role', title: 'Role', dragSort: true },
        { field: 'sex', title: 'Sex' },
        { field: 'age', title: 'Age' },
        { field: 'address', title: 'Address' }
      ],
      data: [
        { id: 10001, name: 'Test1', role: 'Develop', sex: 'Man', age: 28, address: 'test abc' },
        { id: 10002, name: 'Test2', role: 'Test', sex: 'Women', age: 22, address: 'Guangzhou' },
        { id: 10003, name: 'Test3', role: 'PM', sex: 'Man', age: 32, address: 'Shanghai' },
        { id: 10004, name: 'Test4', role: 'Designer', sex: 'Women', age: 24, address: 'Shanghai' }
      ]
    }
    return {
      gridOptions
    }
  },
  methods: {
    resultEvent () {
      const $grid = this.$refs.gridRef
      if ($grid) {
        const { visibleColumn } = $grid.getTableColumn()
        console.log(visibleColumn)
      }
    }
  }
}
</script>

可編輯表格

<template>
  <div>
    <vxe-grid v-bind="gridOptions"></vxe-grid>
  </div>
</template>

<script>
export default {
  data () {
    const gridOptions = {
      border: true,
      showOverflow: true,
      editConfig: {
        trigger: 'click',
        mode: 'cell'
      },
      columns: [
        { type: 'seq', width: 70 },
        { field: 'name', title: 'Name', editRender: { name: 'input' } },
        { field: 'sex', title: 'Sex', editRender: { name: 'input' } },
        { field: 'age', title: 'Age', editRender: { name: 'input' } }
      ],
      data: [
        { id: 10001, name: 'Test1', role: 'Develop', sex: 'Man', age: 28, address: 'test abc' },
        { id: 10002, name: 'Test2', role: 'Test', sex: 'Women', age: 22, address: 'Guangzhou' },
        { id: 10003, name: 'Test3', role: 'PM', sex: 'Man', age: 32, address: 'Shanghai' },
        { id: 10004, name: 'Test4', role: 'Designer', sex: 'Women', age: 24, address: 'Shanghai' }
      ]
    }
    return {
      gridOptions
    }
  }
}
</script>

資料校驗

<template>
  <div>
    <div>
      <vxe-button @click="validEvent">校驗變動資料</vxe-button>
      <vxe-button @click="fullValidEvent">校驗全量資料</vxe-button>
    </div>
    <vxe-grid ref="gridRef" v-bind="gridOptions"></vxe-grid>
  </div>
</template>

<script>
import { VxeUI } from 'vxe-table'
export default {
  data () {
    const gridOptions = {
      border: true,
      showOverflow: true,
      keepSource: true,
      height: 300,
      editConfig: {
        trigger: 'click',
        mode: 'row',
        showStatus: true
      },
      editRules: {
        role: [
          { required: true, message: '必須填寫' }
        ]
      },
      columns: [
        { type: 'checkbox', width: 60 },
        { type: 'seq', width: 70 },
        { field: 'name', title: 'Name', editRender: { name: 'VxeInput' } },
        { field: 'role', title: 'Role', editRender: { name: 'VxeInput' } },
        { field: 'sex', title: 'Sex', editRender: { name: 'VxeInput' } },
        { field: 'age', title: 'Age', editRender: { name: 'VxeInput' } },
        { field: 'date', title: 'Date', editRender: { name: 'VxeInput' } }
      ],
      data: [
        { id: 10001, name: 'Test1', role: 'Develop', sex: '0', age: 28, address: 'test abc' },
        { id: 10002, name: '', role: 'Test', sex: '1', age: 22, address: 'Guangzhou' },
        { id: 10003, name: 'Test3', role: 'PM', sex: '', age: 32, address: 'Shanghai' },
        { id: 10004, name: 'Test4', role: 'Designer', sex: '', age: 23, address: 'test abc' },
        { id: 10005, name: '', role: '', sex: '1', age: 30, address: 'Shanghai' },
        { id: 10006, name: 'Test6', role: 'Designer', sex: '1', age: 21, address: 'test abc' }
      ]
    }
    return {
      gridOptions
    }
  },
  methods: {
    async validEvent () {
      const $grid = this.$refs.gridRef
      if ($grid) {
        const errMap = await $grid.validate()
        if (errMap) {
          VxeUI.modal.message({ status: 'error', content: '校驗不透過！' })
        } else {
          VxeUI.modal.message({ status: 'success', content: '校驗成功！' })
        }
      }
    },
    async fullValidEvent () {
      const $grid = this.$refs.gridRef
      if ($grid) {
        const errMap = await $grid.validate(true)
        if (errMap) {
          VxeUI.modal.message({ status: 'error', content: '校驗不透過！' })
        } else {
          VxeUI.modal.message({ status: 'success', content: '校驗成功！' })
        }
      }
    }
  }
}
</script>

表格搜尋

<template>
  <div>
    <p>
      <vxe-input v-model="filterName" type="search" placeholder="試試全表搜尋" @keyup="searchEvent"></vxe-input>
    </p>

    <vxe-grid v-bind="gridOptions" class="mylist-grid"></vxe-grid>
  </div>
</template>

<script>
import XEUtils from 'xe-utils'
export default {
  data () {
    const tableAllData = [
      { id: 10001, name: 'Test1', role: 'Develop', sex: '0', age: 28, amount: 888, address: 'test abc' },
      { id: 10002, name: 'Test2', role: 'Test', sex: '1', age: 22, amount: 666, address: 'Guangzhou' },
      { id: 10003, name: 'Test3', role: 'PM', sex: '1', age: 32, amount: 89, address: 'Shanghai' },
      { id: 10004, name: 'Test4', role: 'Designer', sex: '0', age: 23, amount: 1000, address: 'test abc' },
      { id: 10005, name: 'Test5', role: 'Develop', sex: '0', age: 30, amount: 999, address: 'Shanghai' },
      { id: 10006, name: 'Test6', role: 'Designer', sex: '0', age: 21, amount: 998, address: 'test abc' },
      { id: 10007, name: 'Test7', role: 'Test', sex: '1', age: 29, amount: 2000, address: 'test abc' },
      { id: 10008, name: 'Test8', role: 'Develop', sex: '1', age: 35, amount: 999, address: 'test abc' },
      { id: 10009, name: 'Test9', role: 'Test', sex: '1', age: 26, amount: 2000, address: 'test abc' },
      { id: 100010, name: 'Test10', role: 'Develop', sex: '1', age: 21, amount: 666, address: 'test abc' }
    ]
    const gridOptions = {
      border: true,
      height: 400,
      columnConfig: {
        useKey: true
      },
      rowConfig: {
        useKey: true
      },
      columns: [
        { type: 'seq', width: 70 },
        { field: 'name', title: 'Name', type: 'html' },
        { field: 'sex', title: 'Sex', type: 'html' },
        { field: 'age', title: 'Age', type: 'html' },
        { field: 'address', title: 'Address', type: 'html' }
      ],
      data: []
    }
    return {
      gridOptions,
      filterName: '',
      tableAllData
    }
  },
  methods: {
    handleSearch () {
      const filterVal = String(this.filterName).trim().toLowerCase()
      if (filterVal) {
        const filterRE = new RegExp(filterVal, 'gi')
        const searchProps = ['name', 'role', 'age', 'address']
        const rest = this.tableAllData.filter(item => searchProps.some(key => String(item[key]).toLowerCase().indexOf(filterVal) > -1))
        this.gridOptions.data = rest.map(row => {
          // 搜尋為克隆資料，不會汙染源資料
          const item = XEUtils.clone(row)
          searchProps.forEach(key => {
            item[key] = String(item[key]).replace(filterRE, match => `<span class="keyword-highlight">${match}</span>`)
          })
          return item
        })
      } else {
        this.gridOptions.data = this.tableAllData
      }
    },
    // 節流函式,間隔500毫秒觸發搜尋
    searchEvent: XEUtils.throttle(function () {
      this.handleSearch()
    }, 500, { trailing: true, leading: true })
  },
  created () {
    this.handleSearch()
  }
}
</script>

<style lang="scss" scoped>
.mylist-grid {
  ::v-deep(.keyword-highlight)  {
    background-color: #FFFF00;
  }
}
</style>

3款線上表格工具推薦
2020-10-28
編輯推薦之《推薦系統》
2013-04-23
開源推薦，靈活多變功能強大的CMDB
2023-11-23
最強 Java 書單推薦，附學習方法
2020-09-07
Java
效能依舊強大上代旗艦智慧手機大推薦
2015-07-31
Vue引入vxe-table（一個功能非常強大的表格元件）
2024-07-04
Vue元件
強烈推薦的軟體
2020-04-07
element封裝可編輯表格元件
2020-01-28
封裝元件
Mac版強大的滑鼠增強推薦：BetterMouse中文版
2024-01-05
Mac
強烈推薦的 Chrome 外掛
2019-01-23
Chrome
足球推薦最準確網站免費足球分析推薦
2022-11-19
網站
5個強大的Java分散式快取框架推薦
2014-11-17
Java分散式快取框架
求推薦好用的視覺化大屏軟體？強推奧威BI
2023-10-08
視覺化
封裝Vue Element的可編輯table表格元件
2021-02-05
封裝Vue元件
我最喜歡的白版應用，AI加持的新功能開源！強烈推薦
2023-12-05
AI
牆裂推薦最適合Linux程式設計的十大文字編輯器
2018-05-07
Linux程式設計
視覺化之資料視覺化最強工具推薦
2023-02-27
視覺化
推薦一款功能強大的Tomcat 管理監控工具，可替代Tomcat Manager
2018-09-12
Tomcat
推薦一款介面優雅、功能強大的 .NET + Vue 許可權管理系統
2024-08-05
Vue
線上HTML編輯器推薦
2012-06-19
HTML
10 個 Flutter 元件推薦 - 2
2022-05-18
Flutter元件
Google 出品的 Java 編碼規範，強烈推薦！
2022-12-06
GoJava
暢玩光追遊戲，最強 RTX 2060遊戲本推薦
2019-09-18
遊戲
國內幾款功能強大適合自媒體的wordpress主題推薦
2020-11-23
Spotify 每週推薦功能：基於機器學習的音樂推薦
2019-02-27
機器學習
提升終端SSH體驗，推薦強大的SecureCRT forMac/win工具
2024-01-20
SecurecrtORMMac
開源而又強大的迷你型web伺服器推薦
2013-12-27
Web伺服器
譯 10 個 Flutter 元件推薦 – 4
2022-05-22
Flutter元件
譯 10 個 Flutter 元件推薦 – 5
2022-05-24
Flutter元件
購機只選3GB運存市售最強大運存智慧手機推薦
2015-11-11
mac最強深度清理推薦：App Cleaner & Uninstaller 啟用中文版
2023-12-27
MacAPP
機器學習知識體系 (強烈推薦)
2018-06-14
機器學習
推薦5款小而強大的工具，讓生活更便捷豐富
2024-01-03
我最推薦的一本技術書
2020-04-23
史上最簡單的推薦系統設計
2019-05-11
轉---推薦最容易成功的創業模式
2009-02-01
創業模式
強烈推薦閻宏博士的java與模式
2002-11-27
Java模式
工具推薦｜2020年最值得推薦的10款UI動效設計工具
2020-01-16
UI

推薦 vue2、vue3 中功能最強大的表格元件，效能最強大的表格元件推薦、可編輯表格推薦

基礎使用

多選

單選

單元格合併

標題字首提示

凍結列

樹表格

行與列拖拽調整順序

可編輯表格

資料校驗

表格搜尋

相關文章