Handsontable example
HTML
<div id="example1"></div>
CSS
</style>
<script src="https://cdn.jsdelivr.net/npm/handsontable@7.3.0/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@7.3.0/dist/handsontable.full.min.css">
JavaScript
var example = document.getElementById('example1');
var hot = new Handsontable(example, {
});
var colHeaders = ['Sample ID', 'Sample Type' , 'Project Name'];
var myjs = '[{"SampleID":"1131893","Sample Type":"Clinical","Project Name" :"Test Project"},{"SampleID":"113189","Sample Type":"Clinical","Project Name":"Test Project"},{"SampleID":"1131893","Sample Type":"Clinical","Project Name":"Test Project"}]';
hot.updateSettings({
data: JSON.parse(myjs),
colHeaders: colHeaders,
columns: [
{data: 'SampleID'}, {data: 'Sample Type'}, {data: 'Project Name'}
]
})
console.log(JSON.parse(myjs))