Handsontable example
by Luiz Vargas
HTML
<div>
<div id="example1" class="hot handsontable htRowHeaders htColumnHeaders"></div>
</div>
CSS
</style><!-- Ugly Hack due to jsFiddle issue -->
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/handsontable.full.min.css">
JavaScript
var example1 = document.getElementById('example1');
var hot = new Handsontable(example1, {
data: Handsontable.helper.createSpreadsheetData(5,10),
colHeaders: false,
rowHeaders: false,
fixedColumnsLeft: 1,
mergeCells: [
{row: 0, col:0, rowspan: 1, colspan: 1},/*VACIO*/
{row: 0, col:1, rowspan: 1, colspan: 19},/*EQUIPO*/
{row: 0, col:21, rowspan: 1, colspan: 2},/*EQUIPO le falta algo*/
//{row: 1, col:0, rowspan: 2, colspan: 1},
//{row: 1, col:1, rowspan: 2, colspan: 1},/*OFICINAS*/
//{row: 1, col:3, rowspan: 2, colspan: 1},
{row: 1, col:1, rowspan: 1, colspan: 4},/*INDICADOR*/
{row: 1, col:5, rowspan: 1, colspan: 4},
{row: 1, col:9, rowspan: 1, colspan: 4},
{row: 1, col:13, rowspan: 1, colspan: 4},
{row: 1, col:21, rowspan: 1, colspan: 2},
],
});