Handsontable example
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/handsontable@7.4.2/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@7.4.2/dist/handsontable.full.min.css">
JavaScript
var example1 = document.getElementById('example1');
var hot = new Handsontable(example1, {
data: Handsontable.helper.createSpreadsheetData(5, 19),
colHeaders: true,
rowHeaders: true,
viewportColumnRenderingOffset: 70,
colWidths: 100,
nestedHeaders: [
[{
label: '選択',
colspan: 2
}, {
label: '倉庫',
colspan: 2
},
{
label: '出荷指示日',
colspan: 2
},
{
label: '作業状況',
colspan: 2
}, '指示回数', 'バッチ番号', 'バッチ名称', '納品先数', '行数', {
label: '出庫指示数',
colspan: 3
}, {
label: '出庫数',
colspan: 3
}
], // 14
['', '', '', '', '', '', '', '', {
label: 'ケース数',
colspan: 1
}, {
label: 'バラ数',
colspan: 1
}, {
label: '総バラ数',
colspan: 1
}, {
label: 'ケース数',
colspan: 1
}, {
label: 'バラ数',
colspan: 1
}, {
label: '総バラ数',
colspan: 1
}] //14
]
});