vxe-table 导入 excel xlsx 时，单元格内容值丢失前面0解决方法

vxe-table 导入 excel xlsx 时，单元格内容值丢失前面0解决方法，不如到出数据为 “003200” ，导出到 xlsx 时，由于 xlsx 会自定义格式化数字，所以 0 就没了；解决方法就是知道为字符串类型，可以通过 column.cell-type 设置

查看官网：https://vxetable.cn
gitbub：https://github.com/x-extends/vxe-table
gitee：https://gitee.com/x-extends/vxe-table

<template><div><vxe-button@click="exportEvent">直接导出 XLSX 文件</vxe-button><vxe-gridref="gridRef"v-bind="gridOptions"></vxe-grid></div></template><scriptsetup>import{ref,reactive}from'vue'constgridRef=ref()constgridOptions=reactive({border:true,showFooter:true,columns:[{field:'seq',type:'seq',width:70},{title:'分组1',children:[{field:'name',title:'Name'},{field:'role',title:'Role'}]},{field:'sex',title:'Sex'},{field:'age',title:'Age',formatter({cellValue}){return`内容：${cellValue}`},footerFormatter({itemValue}){return`尾部：${itemValue}`}},{field:'no1',title:'NO1'},{field:'no2',title:'NO2 String',cellType:'string'}],data:[{id:10001,name:'张三',role:'Develop',sex:'Man',age:28,no1:'028',no2:'028'},{id:10002,name:'李四',role:'研发',sex:'Women',age:36,no1:'220',no2:'220'},{id:10003,name:'王五',role:'产品经理',sex:'Man',age:44,no1:'003200',no2:'003200'},{id:10004,name:'老六',role:'Designer',sex:'Women',age:38,no1:'02040',no2:'02040'}],footerData:[{seq:'合计',name:'12人',age:'999',no1:'356'}]})constexportEvent=()=>{const$grid=gridRef.valueif($grid){$grid.exportData({type:'xlsx'})}}</script>

https://gitee.com/x-extends/vxe-table