特效描述:利用js实现 在线编辑 excel 表格代码。利用js实现在线编辑excel表格代码
代码结构
1. 引入CSS
2. 引入JS
3. HTML代码
function load(){
x.spreadsheet('#x-spreadsheet-demo')
.loadData({
freeze: 'C3',
styles: [
{
bgcolor: '#f4f5f8',
textwrap: true,
color: '#900b09',
border: {
top: ['thin', '#0366d6'],
bottom: ['thin', '#0366d6'],
right: ['thin', '#0366d6'],
left: ['thin', '#0366d6'],
},
},
],
merges: [
'C3:D4',
],
rows: {
1: {
cells: {
0: { text: 'testingtesttestetst' },
2: { text: 'testing' },
},
},
2: {
cells: {
0: { text: 'render', style: 0 },
1: { text: 'Hello' },
2: { text: 'haha', merge: [1, 1] },
}
},
8: {
cells: {
8: { text: 'border test', style: 0 },
}
}
},
}).change((cdata) => console.log(cdata));
}