Handsontable example
HTML
<div id="example1" class="hot handsontable htColumnHeaders"></div>
CSS
</style><!-- Ugly Hack due to jsFiddle issue --> <script src="https://docs.handsontable.com/pro/1.3.4/bower_components/handsontable-pro/dist/handsontable.full.min.js"></script> <link type="text/css" rel="stylesheet" href="https://docs.handsontable.com/pro/1.3.4/bower_components/handsontable-pro/dist/handsontable.full.min.css">
JavaScript
document.addEventListener("DOMContentLoaded", function() {
var data = [{
id: 1,
flag: 'EUR',
currencyCode: 'EUR',
currency: 'Euro',
level: 0.9033,
units: 'EUR / USD',
asOf: '08/19/2015',
onedChng: 0.0026
}, {
id: 2,
flag: 'JPY',
currencyCode: 'JPY',
currency: 'Japanese Yen',
level: 124.3870,
units: 'JPY / USD',
asOf: '08/19/2015',
onedChng: 0.0001
}];
var
container = document.getElementById('example1'),
hot;
hot = new Handsontable(container, {
data: data,
colHeaders: true,
columns: [{
data: 'id',
type: 'numeric'
}, {
data: 'flag'
}, {
data: 'currencyCode'
}, {
data: 'currency'
}, {
data: 'level',
type: 'numeric'
}, {
data: 'units',
type: 'numeric'
}, {
data: 'asOf'
}, {
data: 'onedChng',
type: 'numeric'
}],
cells: function(row, col, prop) {
var cellProperties = {};
if (row === 1 && col === 3) {
cellProperties.renderer = 'html';
}
return cellProperties;
},
});
hot.setDataAtCell(1, 3, 'Japanese <br> Yen')
});