Uniapp 5+app 安卓端导入excel数据

导入excel数据为json数据

/**  
 * Read/Write data to a file using Plus.io API  
 * @param {string} filename Name of the file  
 * @param {string} data Data to be written (only applicable for write operation)  
 * @param {string} type Operation type (1: read, 2: write)  
 * @returns {Promise} Promise that resolves with file data (only applicable for read operation) or empty string (for write operation)  
 */  
function fileOperation(filename, data, type) {  
    return new Promise((resolve, reject) => {  
        plus.io.requestFileSystem(  
            plus.io.PUBLIC_DOCUMENTS,  
            (fs) => {  
                fs.root.getFile(  
                    filename, {  
                        create: type === '2'  
                    },  
                    (fileEntry) => {  
                        if (type === '1') {  
                            fileEntry.file(  
                                (file) => {  
                                    const reader = new plus.io.FileReader()  
                                    reader.onloadend = (evt) => {  
                                        resolve(evt.target.result)  
                                    }  
                                    reader.readAsText(file)  
                                },  
                                (error) => reject(error)  
                            )  
                        } else {  
                            fileEntry.createWriter(  
                                (writer) => {  
                                    writer.onwrite = () => {  
                                        resolve('')  
                                    }  
                                    writer.write(data)  
                                },  
                                (error) => reject(error)  
                            )  
                        }  
                    },  
                    (error) => reject(error)  
                )  
            },  
            (error) => reject(error)  
        )  
    })  
}  

                        importData() {  
                            let resArr = [];  

                            fileOperation('data.xlsx', '', '1').then(data => {  
                                console.log(data);  
                                tab = data.substring(data.indexOf('<table>') + 7, data.indexOf(  
                                    '</table></body>'))  
                                tab = tab.replaceAll(  
                                    '<tr><td>地址</td><td>项目名称</td><td>其他</td><td>费用</td><td>电话号码                                         </td><td>录入时间</td><td>编号</td></tr>',  
                                    '')  
                                console.log(tab)  
                                let doc = document.createElement('table')  
                                doc.innerHTML = tab  
                                console.log(doc);  
                                // 获取所有tr  
                                let trArr = doc.querySelectorAll('tr');  

                                for (let i = 0; i < trArr.length; i++) {  
                                    let tdArr = trArr[i].querySelectorAll('td');  

                                    resArr.push({  
                                        "address": tdArr[0].innerHTML,  
                                        "project": tdArr[1].innerHTML,  
                                        "other": tdArr[2].innerHTML,  
                                        "money": tdArr[3].innerHTML,  
                                        "phone": tdArr[4].innerHTML,  
                                        "created_at": tdArr[5].innerHTML,  
                                        "id": tdArr[6].innerHTML,  
                                        "index": i  
                                    });  
                                }  

                                console.log(JSON.stringify(resArr));  

                            }).catch(error => console.log(error))  
                        },