initializeJSON_wev8.js
4.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
var initJSON_moreContent = {
"tabStripVisible": false,
"newTabVisible": false,
"canUserEditFormula": false,
"allowUndo": false,
"allowDragDrop": false,
"allowDragFill": false,
"highlightInvalidData": true,
"backgroundImageLayout": 3,
"grayAreaBackColor": "white",
"sheets": {
"Sheet1": {
"name": "Sheet1",
"defaults": {
"rowHeight": 30,
"colWidth": 40,
"rowHeaderColWidth": 0,
"colHeaderRowHeight": 0
},
"columns": [
{
"size": 252,
"dirty": true
},
{
"size": 50,
"dirty": true
}
],
"rowCount": 8,
"columnCount": 2,
"gridline": {
"color": "#D0D7E5",
"showVerticalGridline": true,
"showHorizontalGridline": true
},
"allowDragDrop": false,
"allowDragFill": false
}
}
};
//主面板初始化模板格式
var templteStrModel = {
'activeSheetIndex':0, 'sheetCount':1, 'tabStripRatio':0.5,
'tabStripVisible':false, 'tabEditable':true, 'newTabVisible':false, 'referenceStyle':0,
'useWijmoTheme':false, 'canUserEditFormula':true, 'startSheetIndex':0, 'allowUndo':true,
'allowUserZoom':true, 'allowUserResize':true, 'allowDragDrop':true, 'allowDragFill':true,
'highlightInvalidData':true,
'sheets':{'Sheet1':{
'name':'Sheet1',
'defaults':{ //默认的行高列宽
'rowHeight':28, 'colWidth':90,
'rowHeaderColWidth':40, 'colHeaderRowHeight':20
},
'columns':{}, 'rows':{}, //设置行高列宽的数组
'autoGenerateColumns':true, 'dataSource':null,
'frozenRowCount':0, //冻结行
'frozenColCount':0, //冻结列
'rowCount':20, //表格行数
'columnCount':10, //表格列数
'data':{'name':'Sheet1', 'rowCount':20, 'colCount':10,
'dataTable':{}, //数据填充，包括单元格样式，边框等等
'_rowDataArray':[], '_columnDataArray':[],
'_defaultDataNode':{'style':{'foreColor':'black', 'hAlign':3, 'vAlign':0}}
},
'spans':{}, //合并单元格
'selections':{
},
'activeRow':0, 'activeCol':0,
'gridline'://单元格分割线的信息
{
'color':'#D0D7E5', 'showVerticalGridline':true, 'showHorizontalGridline':true
},
'allowCellOverflow':false, 'referenceStyle':0, '_zoomFactor':1,
'theme':{
'_name':'Office', '_themeColor':{
'_name':'Office',
'_colorList':[
{'a':255, 'r':255, 'g':255, 'b':255},
{'a':255, 'r':238, 'g':236, 'b':225},
{'a':255, 'r':0, 'g':0, 'b':0},
{'a':255, 'r':31, 'g':73, 'b':125},
{'a':255, 'r':79, 'g':129, 'b':189},
{'a':255, 'r':192, 'g':80, 'b':77},
{'a':255, 'r':155, 'g':187, 'b':89},
{'a':255, 'r':128, 'g':100, 'b':162},
{'a':255, 'r':75, 'g':172, 'b':198},
{'a':255, 'r':247, 'g':150, 'b':70},
{'a':255, 'r':0, 'g':0, 'b':255},
{'a':255, 'r':128, 'g':0, 'b':128}
]
},
'_headingFont':'Cambria', '_bodyFont':'Calibri'
},
'showRowRangeGroup':true, 'showColumnRangeGroup':true,
'rowRangeGroup':{
'itemsCount':20, 'itemsData':[], 'direction':1, 'head':null, 'tail':null
},
'colRangeGroup':{
'itemsCount':10, 'itemsData':[], 'direction':1, 'head':null, 'tail':null
},
'conditionalFormats':{'rules':[]},
'sheetTabColor':null, 'frozenlineColor':'black',
'rowHeaderAutoText':1, 'colHeaderAutoText':2, 'rowHeaderAutoTextIndex':-1,
'colHeaderAutoTextIndex':-1, 'rowHeaderVisible':true, 'colHeaderVisible':true,
'rowHeaderColCount':1, 'colHeaderRowCount':1,
'rowHeaderData':{
'rowCount':20, 'colCount':1, 'dataTable':{}, '_rowDataArray':[], '_columnDataArray':[],
'_defaultDataNode':{
'style':{'foreColor':'black', 'hAlign':1, 'vAlign':1}
}
},
'colHeaderData':{
'rowCount':1, 'colCount':10, 'dataTable':{}, '_rowDataArray':[], '_columnDataArray':[],
'_defaultDataNode':{
'style':{'foreColor':'black', 'hAlign':1, 'vAlign':1}
}
},
'rowHeaderSpan':{}, 'colHeaderSpan':{}, 'rowHeaderColInfos':{}, 'colHeaderRowInfos':{},
'isProtected':false, 'borderColor':'black', 'borderWidth':0, 'allowDragDrop':true,
'allowDragFill':true, 'allowUndo':true, 'allowEditorReservedLocations':true
}
}, 'names':[]
};