Handsontable example
HTML
<div id="example1" class="hot handsontable htColumnHeaders"></div>
CSS
</style><!-- Ugly Hack due to jsFiddle issue -->
<script src="https://cdn.jsdelivr.net/npm/handsontable@8.0.0/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@8.0.0/dist/handsontable.full.min.css">
<script src="https://handsontable.com/docs/8.3.1/components/numbro/dist/languages.min.js"></script>
JavaScript
var container = document.getElementById('example1'),
hot = new Handsontable(container, {
data: [{car: "Mercedes A 160", year: 2017, price_pound: 7000}],
colHeaders: ['Car', 'Year', 'Price (£)'],
columnSorting : true,
columns: [
{
data: 'car'
},
{
data: 'year',
type: 'numeric'
},
{
data: 'price_pound',
type: 'numeric',
numericFormat: {
pattern: '$0,0.00',
culture: 'en-GB'
}
}
]
});