el-table实现多行合并的效果,并可编辑单元格

背景

数据为数组包对象,对象里面有属性值是数组;无需处理数据,直接使用el-table包el-table的方法,通过修改el-table的样式直接实现多行合并的效果 

html代码

<template>
    <div>
      <el-table size="mini" :data="tableData" v-loading="ruletableLoading" border style="width: 100%" height="calc(100% - 56px)" class="rule-table">
        <el-table-column label="AA" prop="code" show-overflow-tooltip>
          <template #default="scope">
            <!-- <div class="item"> -->
            <div class="cell-content item-normal" @click.stop="cellClick">
              <el-input size="small" class="item__input" v-model="scope.row.code" placeholder="请输入" @blur="handleBlur"></el-input>
              <div class="item__txt">{{ scope.row.code }}</div>
            </div>
          </template>
        </el-table-column>
        <el-table-column label="BB" prop="name" show-overflow-tooltip>
          <template #default="scope">
            <!-- <div class="item"> -->
            <div class="cell-content item-normal" @click.stop="cellClick">
              <el-input size="small" class="item__input" v-model="scope.row.name" placeholder="请输入" @blur="handleBlur"></el-input>
              <div class="item__txt">{{ scope.row.name }}</div>
            </div>
          </template>
        </el-table-column>
        <el-table-column label="CC">
          <template #default="scope">
            <el-table :data="scope.row.items" :border="false" :show-header="false" class="no-border-table">
              <el-table-column prop="name" show-overflow-tooltip>
                <template #default="scope">
                  <!-- <div class="item"> -->
                  <div class="cell-content item-normal" @click.stop="cellClick">
                    <el-input size="small" class="item__input" v-model="scope.row.name" placeholder="请输入" @blur="handleBlur"></el-input>
                    <div class="item__txt">{{ scope.row.name }}</div>
                  </div>
                </template>
              </el-table-column>
            </el-table>
          </template>
        </el-table-column>
        <el-table-column label="DD" width="120">
          <template #default="scope">
            <el-table :data="scope.row.items" :border="false" :show-header="false" class="no-border-table">
              <el-table-column prop="percent" show-overflow-tooltip>
                <template #default="scope">
                  <!-- <div class="item"> -->
                  <div class="cell-content item-normal" @click.stop="cellClick">
                    <el-input size="small" class="item__input" v-model="scope.row.percent" placeholder="请输入" @blur="handleBlur"></el-input>
                    <div class="item__txt">{{ scope.row.percent }}</div>
                  </div>
                </template>
              </el-table-column>
            </el-table>
          </template>
        </el-table-column>

        <el-table-column label="EE" width="120">
          <template #default="scope">
            <el-table :data="scope.row.items" :border="false" :show-header="false" class="no-border-table">
              <el-table-column prop="score" show-overflow-tooltip>
                <template #default="scope">
                  <!-- <div class="item"> -->
                  <div class="cell-content item-normal" @click.stop="cellClick">
                    <el-input size="small" class="item__input" v-model="scope.row.score" placeholder="请输入" @blur="handleBlur"></el-input>
                    <div class="item__txt">{{ scope.row.score }}</div>
                  </div>
                </template>
              </el-table-column>
            </el-table>
          </template>
        </el-table-column>

        <el-table-column label="FF" prop="totalScore" show-overflow-tooltip width="120">
          <template #default="scope">
            <!-- <div class="item"> -->
            <div class="cell-content item-normal" @click.stop="cellClick">
              <el-input size="small" class="item__input" v-model="scope.row.totalScore" placeholder="请输入" @blur="handleBlur"></el-input>
              <div class="item__txt">{{ scope.row.totalScore }}</div>
            </div>
          </template>
        </el-table-column>

        <el-table-column label="GG">
          <template #default="scope">
            <el-table :data="scope.row.classStandard" :border="false" :show-header="false" class="no-border-table">
              <el-table-column prop="express" show-overflow-tooltip>
                <template #default="scope">
                  <!-- <div class="item"> -->
                  <div class="cell-content item-normal" @click.stop="cellClick">
                    <el-input size="small" class="item__input" v-model="scope.row.express" placeholder="请输入" @blur="handleBlur"></el-input>
                    <div class="item__txt">{{ scope.row.express }}</div>
                  </div>
                </template>
              </el-table-column>
            </el-table>
          </template>
        </el-table-column>

        <el-table-column label="HH">
          <template #default="scope">
            <el-table :data="scope.row.classStandard" :border="false" :show-header="false" class="no-border-table">
              <el-table-column prop="class" show-overflow-tooltip>
                <template #default="scope">
                  <!-- <div class="item"> -->
                  <div class="cell-content item-normal" @click.stop="cellClick">
                    <el-input size="small" class="item__input" v-model="scope.row.class" placeholder="请输入" @blur="handleBlur"></el-input>
                    <div class="item__txt">{{ scope.row.class }}</div>
                  </div>
                </template>
              </el-table-column>
            </el-table>
          </template>
        </el-table-column>

        <el-table-column label="II">
          <template #default="scope">
            <el-table :data="scope.row.classStandard" :border="false" :show-header="false" class="no-border-table">
              <el-table-column prop="remark" show-overflow-tooltip>
                <template #default="scope">
                  <div class="cell-content item-normal" @click.stop="cellClick">
                    <el-input size="small" class="item__input" v-model="scope.row.remark" placeholder="请输入" @blur="handleBlur"></el-input>
                    <div class="item__txt">{{ scope.row.remark }}</div>
                  </div>
                </template>
              </el-table-column>
            </el-table>
          </template>
        </el-table-column>
      </el-table>

    </div>
  </template>

js代码 

主要是cellClick和handleBlur控制的,首先需要找到包裹el-input和展示表格文字的父div,然后通过点击父div和el-input的失去焦点事件控制内部这两个元素的显示和隐藏

<script setup>
import { ref, computed,onMounted } from 'vue'
import ruletableDataJson from './ruleManage.json'
import { cloneDeep } from 'lodash'



const tableData=ref([])

onMounted(()=>{
  tableData.value=[
  {
    "id": 9090,
    "code": "1",
    "name": "密码和车好多看",
    "remark": "",
    "items": [
      {
        "id": 6767,
        "name": "合适的客户收款",       
        "percent": 0.7,   
        "score": 100 
      },
      {
        "id": 89808,
        "name": "附近的看法好的",       
        "percent": 0.3,    
        "score": 67 
      }
    ],
    "classStandard": [
      {
        "express": "年卡就诊卡",
        "remark": "活动开始计划的卡号",
        "class": "打开了电视机了"
      },
      {
        "express": "手机多少空间",
        "remark": "简单说来就是了",
        "class": "的"
      },
      {
        "express": "的角度来讲罗迪克",
        "remark": "十九岁的离开拘留所",
        "class": "对手的实力的距离"
      },
      {
        "express": "但是肯定是咯",
        "remark": "发达的",
        "class": "人工费v1"
      },
      {
        "express": "的快捷键",
        "remark": "附近的垃圾分类",
        "class": "分隔符"
      },
      {
        "express": "三大三",
        "remark": "反对反对开始",
        "class": "对顶的"
      },
      {
        "express": "多睡的",
        "remark": "对顶的",
        "class": "对对对对"
      },
      {
        "express": "对顶的",
        "remark": "的舒适性",
        "class": "多睡的"
      },
      {
        "express": "是啥",
        "remark": "都是大客户",
        "class": "山东江苏科技"
      }

    ]
  },
  {
    "id": 9090,
    "code": "2",
    "name": "密码和车好多看",
    "remark": "",
    "items": [
      {
        "id": 6767,
        "name": "合适的客户收款",       
        "percent": 0.7,   
        "score": 100 
      },
      {
        "id": 89808,
        "name": "附近的看法好的",       
        "percent": 0.3,    
        "score": 67 
      }
    ],
    "classStandard": [
      {
        "express": "年卡就诊卡",
        "remark": "活动开始计划的卡号",
        "class": "打开了电视机了"
      },
      {
        "express": "手机多少空间",
        "remark": "简单说来就是了",
        "class": "的"
      },
      {
        "express": "的角度来讲罗迪克",
        "remark": "十九岁的离开拘留所",
        "class": "对手的实力的距离"
      },
      {
        "express": "但是肯定是咯",
        "remark": "发达的",
        "class": "人工费v1"
      },
      {
        "express": "的快捷键",
        "remark": "附近的垃圾分类",
        "class": "分隔符"
      },
      {
        "express": "三大三",
        "remark": "反对反对开始",
        "class": "对顶的"
      },
      {
        "express": "多睡的",
        "remark": "对顶的",
        "class": "对对对对"
      },
      {
        "express": "对顶的",
        "remark": "的舒适性",
        "class": "多睡的"
      },
      {
        "express": "是啥",
        "remark": "都是大客户",
        "class": "山东江苏科技"
      }

    ]
  },
  {
    "id": 9090,
    "code": "3",
    "name": "密码和车好多看",
    "remark": "",
    "items": [
      {
        "id": 6767,
        "name": "合适的客户收款",       
        "percent": 0.7,   
        "score": 100 
      },
      {
        "id": 89808,
        "name": "附近的看法好的",       
        "percent": 0.3,    
        "score": 67 
      }
    ],
    "classStandard": [
      {
        "express": "年卡就诊卡",
        "remark": "活动开始计划的卡号",
        "class": "打开了电视机了"
      },
      {
        "express": "手机多少空间",
        "remark": "简单说来就是了",
        "class": "的"
      },
      {
        "express": "的角度来讲罗迪克",
        "remark": "十九岁的离开拘留所",
        "class": "对手的实力的距离"
      },
      {
        "express": "但是肯定是咯",
        "remark": "发达的",
        "class": "人工费v1"
      },
      {
        "express": "的快捷键",
        "remark": "附近的垃圾分类",
        "class": "分隔符"
      },
      {
        "express": "三大三",
        "remark": "反对反对开始",
        "class": "对顶的"
      },
      {
        "express": "多睡的",
        "remark": "对顶的",
        "class": "对对对对"
      },
      {
        "express": "对顶的",
        "remark": "的舒适性",
        "class": "多睡的"
      },
      {
        "express": "是啥",
        "remark": "都是大客户",
        "class": "山东江苏科技"
      }

    ]
  },
  ]
})

const cellClick = e => {
  let element = e.target.parentNode
  element.classList.remove('item-normal')
  element.classList.add('item-edit')
}

const handleBlur = e => {
  let element = e.target.parentNode.parentNode
  element.classList.remove('item-edit')
  element.classList.add('item-normal')
  dotShow.value=true
}
</script>

scss样式

首先设置cell-content的基础样式;元素饿显示和隐藏就单独拿出来通过在事件中做切换


  <style lang='scss' scoped>

// 对elementplus的样式修改

    .rule-table:deep() .cell {
  padding-left: 0px;
  padding-right: 0px;
}

:deep(.el-table--border) {
  border: none;
}

.rule-table .no-border-table :deep()tr:last-child td {
  border-bottom: none;
}

:deep().el-table::before {
  width: 0%;
  height: 0px;
}
.rule-table .no-border-table :deep()th {
  border-right: none;
}
.rule-table .no-border-table :deep()td {
  border-right: none;
}



// 可编辑

.cell-content {
  cursor: pointer;
  .item__input {
    // display: none;
    width: 95%;
    /* 调整elementUI中样式 如果不需要调整请忽略 */
    .el-input__inner {
      height: 24px !important;
    }
    /* 调整elementUI中样式 如果不需要调整请忽略 */
    .el-input__suffix {
      i {
        font-size: 12px !important;
        line-height: 26px !important;
      }
    }
  }
  .item__txt {
    // display: block;
    box-sizing: border-box;
    line-height: 32px;
    padding: 0 9px;
  }
}
// 单独设置编辑状态和常规状态
.item-edit {
  .item__input {
    display: block;
  }
  .item__txt {
    display: none;
  }
}
.item-normal {
  .item__input {
    display: none;
  }
  .item__txt {
    display: block;
  }
}

  </style>

  • 8
    点赞
  • 10
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
el-tableElement UI框架中的一个表格组件,可以用于展示和编辑数据。要实现Excel中的合并行和合并列功能,可以使用el-table的特定属性和方法。 要实现合并行,可以使用el-table的span-method属性。该属性接受一个函数,用于计算每个单元格合并行数。在函数中,可以根据当前单元格的值和相邻单元格的值来判断是否需要合并行,并返回合并行数。 要实现合并列,可以使用el-table-column的prop属性。该属性指定了当前列对应数据对象中的字段名。如果多个列的prop属性相同,那么这些列将会合并为一列。 下面是一个示例代码,演示了如何使用el-table实现合并行和合并列: ```html <template> <el-table :data="tableData" :span-method="handleSpanMethod"> <el-table-column prop="name" label="姓名"></el-table-column> <el-table-column prop="age" label="年龄"></el-table-column> <el-table-column prop="gender" label="性别"></el-table-column> </el-table> </template> <script> export default { data() { return { tableData: [ { name: '张三', age: 18, gender: '男' }, { name: '李四', age: 20, gender: '女' }, { name: '王五', age: 18, gender: '男' }, { name: '赵六', age: 22, gender: '女' }, ], }; }, methods: { handleSpanMethod({ row, column, rowIndex, columnIndex }) { if (columnIndex === 0) { // 判断当前列是否为第一列 if (rowIndex === 0 || row.name !== this.tableData[rowIndex - 1].name) { // 判断当前行是否为第一行或者与上一行的name字段值不同 const rowspan = this.getRowspan(row.name, columnIndex); if (rowspan > 1) { return { rowspan, colspan: 1, }; } } } }, getRowspan(name, columnIndex) { let rowspan = 1; for (let i = 1; i < this.tableData.length; i++) { if (this.tableData[i].name === name) { rowspan++; } else { break; } } return rowspan; }, }, }; </script> ``` 在上述代码中,handleSpanMethod函数用于计算每个单元格合并行数。getRowspan函数用于计算每个姓名相同的单元格合并行数。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值