Luckysheet如何初始化含合并单元格的数据
问题
Luckysheet是一款功能很丰富的在线电子表格插件,但是初始版本demo不够完善,笔者结合身边朋友的经验,给出合并单元格的案例供参考.
解决方案
先手动设置几个合并单元格,然后控制台使用 luckysheet.getluckysheetfile()
打印sheet信息, 复制出当前页config和data参数,就是合并单元格需要用到的信息,其中data还需要处理下才能用到初始化中使用.
参考的数据转化方案:
// data => celldata
luckysheet.sheetmanage.getGridData(luckysheet.flowdata)
// celldata => data
luckysheet.sheetmanage.buildGridData(file)
代码
luckysheet.create({
container: 'luckysheet',
data: [
{
"name": "分公司",
"color": "",
"config": {
"merge": {
"0_0": {
"rs": 2,
"cs": 1,
"r": 0,
"c": 0
},
"0_1": {
"rs": 1,
"cs": 2,
"r": 0,
"c": 1
},
"0_3": {
"rs": 2,
"cs": 2,
"r": 0,
"c": 3
},
"1_1": {
"rs": 1,
"cs": 2,
"r": 1,
"c": 1
}
},
"rowlen": {}
},
"index": "0",
"chart": [
{
"sheetIndex": "0",
"dataSheetIndex": "0",
"chartType": "column",
"row": "[1,3]",
"column": "[3,3]",
"chartStyle": "default",
"myWidth": "480",
"myHeight": "288",
"myLeft": "67",
"myTop": "11"
}
],
"status": "1",
"order": "0",
"column": 12,
"row": 36,
"celldata": [{"r":0,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"数据1","m":"数据1","mc":{"r":0,"c":0,"rs":2,"cs":1},"ht":"0","vt":"0","bl":1,"bg":"#fce5cd"}},{"r":0,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据2","m":"数据2","mc":{"r":0,"c":1,"rs":1,"cs":2},"ht":"0","bl":1,"bg":"#fce5cd"}},{"r":0,"c":2,"v":{"mc":{"r":0,"c":1},"ht":"0","bl":1,"bg":"#fce5cd"}},{"r":0,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"数据4","m":"数据4","mc":{"r":0,"c":3,"rs":2,"cs":2},"vt":"0","ht":"0","bl":1,"bg":"#fce5cd"}},{"r":0,"c":4,"v":{"mc":{"r":0,"c":3},"vt":"0","ht":"0","bl":1,"bg":"#fce5cd"}},{"r":0,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据6","m":"数据6","bl":1,"bg":"#fce5cd"}},{"r":1,"c":0,"v":{"mc":{"r":0,"c":0},"ht":"0","vt":"0","bl":1,"bg":"#fce5cd"}},{"r":1,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据3","m":"数据3","mc":{"r":1,"c":1,"rs":1,"cs":2},"ht":"0","bl":1,"bg":"#fce5cd"}},{"r":1,"c":2,"v":{"mc":{"r":1,"c":1},"ht":"0","bl":1,"bg":"#fce5cd"}},{"r":1,"c":3,"v":{"mc":{"r":0,"c":3},"vt":"0","ht":"0","bl":1,"bg":"#fce5cd"}},{"r":1,"c":4,"v":{"mc":{"r":0,"c":3},"vt":"0","ht":"0","bl":1,"bg":"#fce5cd"}},{"r":1,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据7","m":"数据7","bl":1,"bg":"#fce5cd"}},{"r":2,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"数据3","m":"数据3"}},{"r":2,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据4","m":"数据4"}},{"r":2,"c":2,"v":{"ct":{"fa":"General","t":"g"},"v":"数据5","m":"数据5"}},{"r":2,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"数据6","m":"数据6"}},{"r":2,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"数据7","m":"数据7"}},{"r":2,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据8","m":"数据8"}},{"r":3,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"数据4","m":"数据4"}},{"r":3,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据5","m":"数据5"}},{"r":3,"c":2,"v":{"ct":{"fa":"General","t":"g"},"v":"数据6","m":"数据6"}},{"r":3,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"数据7","m":"数据7"}},{"r":3,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"数据8","m":"数据8"}},{"r":3,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据9","m":"数据9"}},{"r":4,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"数据5","m":"数据5"}},{"r":4,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据6","m":"数据6"}},{"r":4,"c":2,"v":{"ct":{"fa":"General","t":"g"},"v":"数据7","m":"数据7"}},{"r":4,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"数据8","m":"数据8"}},{"r":4,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"数据9","m":"数据9"}},{"r":4,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据10","m":"数据10"}},{"r":5,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"数据6","m":"数据6"}},{"r":5,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据7","m":"数据7"}},{"r":5,"c":2,"v":{"ct":{"fa":"General","t":"g"},"v":"数据8","m":"数据8"}},{"r":5,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"数据9","m":"数据9"}},{"r":5,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"数据10","m":"数据10"}},{"r":5,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据11","m":"数据11"}},{"r":6,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"数据7","m":"数据7"}},{"r":6,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据8","m":"数据8"}},{"r":6,"c":2,"v":{"ct":{"fa":"General","t":"g"},"v":"数据9","m":"数据9"}},{"r":6,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"数据10","m":"数据10"}},{"r":6,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"数据11","m":"数据11"}},{"r":6,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据12","m":"数据12"}},{"r":7,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"数据8","m":"数据8"}},{"r":7,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据9","m":"数据9"}},{"r":7,"c":2,"v":{"ct":{"fa":"General","t":"g"},"v":"数据10","m":"数据10"}},{"r":7,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"数据11","m":"数据11"}},{"r":7,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"数据12","m":"数据12"}},{"r":7,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据13","m":"数据13"}},{"r":8,"c":0,"v":{"ct":{"fa":"General","t":"g"},"v":"数据9","m":"数据9"}},{"r":8,"c":1,"v":{"ct":{"fa":"General","t":"g"},"v":"数据10","m":"数据10"}},{"r":8,"c":2,"v":{"ct":{"fa":"General","t":"g"},"v":"数据11","m":"数据11"}},{"r":8,"c":3,"v":{"ct":{"fa":"General","t":"g"},"v":"数据12","m":"数据12"}},{"r":8,"c":4,"v":{"ct":{"fa":"General","t":"g"},"v":"数据13","m":"数据13"}},{"r":8,"c":5,"v":{"ct":{"fa":"General","t":"g"},"v":"数据14","m":"数据14"}}],
"visibledatarow": [],
"visibledatacolumn": [],
"rowsplit": [],
"ch_width": 4748,
"rh_height": 1790,
"luckysheet_select_save": [
{
"row": [
0,
1
],
"column": [
0,
0
]
}
],
"luckysheet_selection_range": [],
"scrollLeft": 0,
"scrollTop": 0
}
]
})
更多学习笔记欢迎访问:DuShuSir.com