Handsontable example

by Luiz Vargas

HTML

<div id="example1" class="hot handsontable htRowHeaders htColumnHeaders" style="height: 320px; overflow: hidden; width: 100%;" data-originalstyle="height: 320px; overflow: hidden; width: 100%;"></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 example = document.getElementById('example1');
  var hot = new Handsontable(example, {
     data: Handsontable.helper.createSpreadsheetData(1000, 1000),
     //colWidths: [100, 100, 160,160, 160, 160,160, 160, 160,160, 160, 160],
        width: '100%',
        rowHeaders: false,
        colHeaders: false,
        contextMenu: false,
        preventOverflow: 'horizontal',
        stretchH: 'all',
        mergeCells: [
        {row: 0, col:0, rowspan: 3, 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},

        ],
  });