下面是我的代碼
var xlsx = require('xlsx');
var workbook = xlsx.readFile('E:/React application/userResponse.xlsx');
const sheetnames = workbook.SheetNames[0]
const sheetValue = workbook.Sheets[sheetnames];
var data = xlsx.utils.sheet_add_json(sheetValue);
console.log(data);
當我記錄資料時，我不斷收到以下錯誤
e:\React application\pravinyam-api\node_modules\xlsx\xlsx.js:24131
var range = ({s: {c:0, r:0}, e: {c:_C, r:_R js.length - 1 offset}});
^
TypeError: Cannot read property 'length' of undefined
at Object.sheet_add_json (e:\React application\pravinyam-api\node_modules\xlsx\xlsx.js:24131:51)
at Object.<anonymous> (e:\React application\pravinyam-api\readExcel.js:8:23)
at Module._compile (internal/modules/cjs/loader.js:1085:14)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1114:10)
at Module.load (internal/modules/cjs/loader.js:950:32)
at Function.Module._load (internal/modules/cjs/loader.js:790:12)
at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:75:12)
at internal/main/run_main_module.js:17:47
如果有人對如何閱讀 excel 表或解決上述問題有更好的方法將有很大幫助！謝謝
uj5u.com熱心網友回復：
更改sheet_add_json并sheet_to_json遵循路徑名稱模式。
const xlsx = require("xlsx");
const workbook = xlsx.readFile("E:\\React application\\userResponse.xlsx");
const sheetnames = workbook.SheetNames[0];
const data = xlsx.utils.sheet_to_json(workbook.Sheets[sheetnames]);
console.log(data);
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/503710.html
標籤：javascript 节点.js 擅长