剑道Excel导出& rowSpan
剑道Excel导出& rowSpan
提问于 2016-03-30 23:32:16
我尝试使用kendo.ooxml.Workbook将数据导出到xlsx。它说我可以使用rowSpan，但它似乎是有问题的。当我为A和B列设置不同的行距时，C列中的最后两个单元格将消失：
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
rows: [
{
cells: [
{ value: "a", rowSpan: 3 },
{ value: "b", rowSpan: 2 },
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "b", rowSpan: 4 },
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "a", rowSpan: 3 },
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "c"},
{ value: "d"},
]
},
]
}
]
});
kendo.saveAs({
dataURI: workbook.toDataURL(),
fileName: "Test.xlsx"
});https://jsfiddle.net/92ggxnxn/
但是，如果我为A列和B列设置相同的行跨度，则C列将包含所有值：
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
rows: [
{
cells: [
{ value: "a", rowSpan: 3 },
{ value: "b", rowSpan: 3 },
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "a", rowSpan: 3 },
{ value: "b", rowSpan: 3 },
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "c"},
{ value: "d"},
]
},
{
cells: [
{ value: "c"},
{ value: "d"},
]
},
]
}
]
});
kendo.saveAs({
dataURI: workbook.toDataURL(),
fileName: "Test.xlsx"
});https://jsfiddle.net/pb349fx2/
是虫子，还是我做错什么了？
回答 1
Stack Overflow用户
回答已采纳
发布于 2016-06-07 15:26:09
这绝对是个窃听器。它应该在最新的版本中被修复。请参阅更新的代码段：
https://jsfiddle.net/92ggxnxn/1/
<script src="https://kendo.cdn.telerik.com/2016.2.607/js/kendo.all.min.js"></script>页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/36321600
复制相关文章
相似问题
腾讯云开发者
