Luckysheet config边框设置
Luckysheet在config设置中可以设置合并单元格信息 / 边框颜色 / 每行的高度 / 每列的宽度
1. 合并单元格信息
merge下的key为"r_c"的格式,指定了左上角单元格的位置信息,
"r":左上角单元格在第几行; "c":左上角单元格在第几列; "rs":合并的行数, "rs":合并的列数
例如:
"merge": {
"13_5": {
"r": 13,
"c": 5,
"rs": 3,
"cs": 1
},
"13_7": {
"r": 13,
"c": 7,
"rs": 3,
"cs": 2
},
"14_2": {
"r": 14,
"c": 2,
"rs": 1,
"cs": 2
}
},
2. 边框信息
rangeType: "range" 或者 "cell"
rangeType为"range"时: borderType: "border-left" / "border-right" / "border-top" /"border-bottom" / "border-all" / "border-outside" / "border-inside" / "border-horizontal" / "border-vertical" / "border-none",
rangeType为"cell"时: 需要设置"l" / "r" / "t" / "b"
具体可以搜索源码 getBorderInfoCompute 查看
例如:
"borderInfo": [{
"rangeType": "cell",
"value": {
"row_index": 3,
"col_index": 3,
"l": {
"style": 10,
"color": "rgb(255, 0, 0)"
},
"r": {
"style": 10,
"color": "rgb(255, 0, 0)"
},
"t": {
"style": 10,
"color": "rgb(255, 0, 0)"
},
"b": {
"style": 10,
"color": "rgb(255, 0, 0)"
}
}
}, {
"rangeType": "range",
"borderType": "border-none",
"style": "2",
"color": "#000",
"range": [{
"row": [3, 3],
"column": [3, 4]
}]
}]
综合配置信息,可以参考以下可执行的初始化配置:
Luckysheet