const chooseFile = () => {
Taro.chooseMessageFile({
count: 1,
type: 'file',
extension: ['.xls', '.xlsx'],
success: function (res) {
try {
const path = res.tempFiles[0].path
const fs = Taro.getFileSystemManager()
const data = fs.readFileSync(path, 'binary') // data为binary数据
process(data)
} catch (e) {
console.error(e)
Taro.showModal({
title: '提示',
content: "文件读取失败",
showCancel: false
})
return
}
}
})
}
const process = (data) => {
let workbook = XLSX.read(data, {
type: "binary"
});
const sheetName = workbook.SheetNames[0]
let sheet = workbook.Sheets[sheetName]
const options = {
raw: false // 如果不加raw:true的话日期会被读成数字,根据开发需求决定
}
const rawData = XLSX.utils.sheet_to_json(sheet, options);
console.log('rawData===', rawData)
// do something
}
Taro+vue小程序解析excel
最新推荐文章于 2024-05-10 22:17:54 发布