xlsx 图表在添加多个图表选项时出现错误(设置"C：ser")

Question

我在使用xlsx-chart时遇到了困难…我使用xlsx-chart在Excel中创建一个图表，但是当我在选项中添加多个图表时，我有一个像下面这样的问题

TypeError: Cannot set properties of undefined (setting 'c:ser')
at /node_modules/xlsx-chart/chart/base.js:508:83
at Function.each (/node_modules/underscore/underscore-node-f-pre.js:1321:7)

这是我的选项对象

const xlsxChart = new XLSXChart();
const opts = {
charts: [
{
chart: 'line',
titles: ['inside', 'outside'],
fields: [
'29-06-2022, 14:15:01',
'29-06-2022, 14:30:10',
],
data: {
outside: {
'29-06-2022, 14:15:01': 44,
'29-06-2022, 14:30:10': 42,
},
inside: {
'29-06-2022, 14:15:01': 37,
'29-06-2022, 14:30:10': 35,
},
},
chartTitle: 'Temperature',
},
{
chart: 'column',
titles: ['inside', 'outside'],
fields: [
'29-06-2022, 14:15:01',
'29-06-2022, 14:30:10',
],
data: {
outside: {
'29-06-2022, 14:15:01': 66,
'29-06-2022, 14:30:10': 67,
},
inside: {
'29-06-2022, 14:15:01': 91,
'29-06-2022, 14:30:10': 92,
},
},
chartTitle: 'humidity',
},
],
};

有谁能帮帮我吗

Answer 1

我已经发现一个拉请求可以解决这个问题在这个提交

你只需将下面的代码块添加到package

中的base.js文件中

else if (chart == "line") {
o ["c:chartSpace"]["c:chart"]["c:plotArea"]["c:lineChart"] = o ["c:chartSpace"]["c:chart"]["c:plotArea"]["c:lineChart"] || o ["c:chartSpace"]["c:chart"]["c:plotArea"]["c:barChart"];
delete o ["c:chartSpace"]["c:chart"]["c:plotArea"]["c:barChart"];
delete o ["c:chartSpace"]["c:chart"]["c:plotArea"]["c:lineChart"]["c:barDir"];
o ["c:chartSpace"]["c:chart"]["c:plotArea"]["c:lineChart"]["c:grouping"] = { $: { val: 'standard' } };
if (me.tplName == "charts") {
o ["c:chartSpace"]["c:chart"]["c:plotArea"]["c:lineChart"][1]["c:ser"] = ser;
} else {
o ["c:chartSpace"]["c:chart"]["c:plotArea"]["c:lineChart"]["c:ser"] = ser;
};
}

进入回调_.each (ser, function (ser, chart) {