在线 html 表格控件,Html下显示表格插件-handsontable

options:https://github.com/handsontable/handsontable/wiki/Options

官方网页：http://handsontable.com/

实例：

({

data: [

['', '', '千订单差评量', '', '', '', '', '', '', '', ''],

['', '', '合计', '5月', '6月', '7月', '8月', '9月', '10月', '11月', '12月'],

['区域属性', 'A运行中心', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', 'B运行中心', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', 'C运行中心', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', 'D运行中心', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', 'E运行中心', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', 'F运行中心', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', 'G运行中心', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', 'H运行中心', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '无区域', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店1', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店2', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店3', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店4', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店5', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店6', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店7', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店8', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '直营店9', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

['', '合计', '25.0', '28.4', '29.1', '25.2', '23.9', '24.0', '21.2', '25.9', '23.2'],

],//需要修改

columns:[

{readOnly:true},{readOnly:true},{readOnly:true},{readOnly:true},{readOnly:true},{readOnly:true},{readOnly:true},{readOnly:true},{readOnly:true},{readOnly:true},{readOnly:true}

],//需要修改

autoColumnSize:true,

autoWrapCol: true,

autoWrapRow: true,

colHeaders: true,

rowHeaders: false,

//columnSorting: true,//是否打开列排序 默认是false

fixedColumnsLeft: 2,//允许对表的左边的列中指定的固定(又名冻结)的数

fixedRowsTop: 2,//允许对表的顶部指定行数固定的(又名冻结)的数

mergeCells: [

//{ row: 0, col: 0, rowspan: 2, colspan: 2 },

{ row: 2, col: 0, rowspan: 19, colspan: 1 },

{ row: 0, col: 2, rowspan: 1, colspan: 9 }

],//合并的列

enterBeginsEditing: false,

manualColumnResize: true,

manualRowResize: true,

})