vxe-table 导入 excel xlsx 时，单元格内容值丢失前面0解决方法
<p>vxe-table 导入 excelxlsx 时，单元格内容值丢失前面0解决方法，不如到出数据为 "003200" ，导出到 xlsx 时，由于 xlsx 会自定义格式化数字，所以 0 就没了；解决方法就是知道为字符串类型，可以通过 column.cell-type 设置</p><p>查看官网：https://vxetable.cn<br>
gitbub：https://github.com/x-extends/vxe-table<br>
gitee：https://gitee.com/x-extends/vxe-table</p>
<p><img src="https://img2024.cnblogs.com/blog/3563285/202512/3563285-20251222094606788-1637526284.png"></p>
<p><img src="https://img2024.cnblogs.com/blog/3563285/202512/3563285-20251222094742987-1931017015.png"></p>
<pre><code class="language-html"><template>
<div>
<vxe-button @click="exportEvent">直接导出 XLSX 文件</vxe-button>
<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,
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' }
]
})
const exportEvent = () => {
const $grid = gridRef.value
if ($grid) {
$grid.exportData({
type: 'xlsx'
})
}
}
</script>
</code></pre>
<p>https://gitee.com/x-extends/vxe-table</p><br><br>
来源：https://www.cnblogs.com/qaz666/p/19380894
頁:
[1]