我正在使用名为js-xlsx的软件包链接:https://github.com/SheetJS/js-xlsx
问题:如何解析带有合并的xlsx以输出json? Here is what the excel sheet looks like:最后,json应如下所示:
[
{
"Nuber": 1,
"Department": "part1",
"Unit": ["check","second","cable"],
"BeginTime": "1/7:00",
"EndTime": "2/20:00",
"Worker": ["Lucy","Jussa","Peter"]
},
{
"Nuber": 2,
"Department": "part2",
"Unit": "check",
"BeginTime": "1/7:00",
"EndTime": "1/20:00",
"Worker": "Yu"
}
]
test.js:
XLSX = require('xlsx');
var workbook = XLSX.readFile('test.xlsx');
var sheet_name_list = workbook.SheetNames;
sheet_name_list.forEach(function(y) { /* iterate through sheets */
var worksheet = workbook.Sheets[y];
for (z in worksheet) {
/* all keys that do not begin with "!" correspond to cell addresses */
if(z[0] === '!') continue;
}
});
1 回答
得到:
如您所见,数字将转换为字符串 . 我不知道是否有选项可以将数字保存为数字 . 与Papa Parse的解决方法:
结果是: