HTML
<div id="handsontable"></div>
<script>
// Defines the data in the table
const data = [
["A", "0", 1.5, "0", 1.50, "0", 1.50, "0"],["AA1", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB", "1", 1.50, "0", 1.50, "0", 1.50, "0"],["AB10", "1", 1.50, "0", 1.50, "0", 1.50, "0"],["AB11", "1", 1.50, "0", 1.50, "0", 1.50, "0"],["AB12", "1", 1.50, "0", 1.50, "0", 1.50, "0"],["AB13", "1", 1.50, "0", 1.50, "0", 1.50, "0"],["AB14", "1", 1.50, "0", 1.50, "0", 1.50, "0"],["AB15", "1", 1.50, "0", 1.50, "0", 1.50, "0"],["AB16", "1", 1.50, "0", 1.50, "0", 1.50, "0"],["AB21", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB22", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB23", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB24", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB25", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB30", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB31", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB32", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB33", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB34", "0", 1.50, "0", 1.50, "0", 1.50, "0"],["AB35", "0", 1.50, "0", 1.50, "0", 1.50, "0"]
];
// Defines the container to put the data in
const container = document.getElementById( 'handsontable' );
// Instantiates Handsontable
const hot = new Handsontable( container, {
data: data,
className: 'htLeft',
stretchH: 'all',
contextMenu: ['row_above', 'row_below', 'remove_row'],
fillHandle: false,
rowHeaders: true,
colHeaders: ["Postcode", "Next Day", "Next Day Cost", "Standard", "Standard Cost", "Saturday", "Saturday Cost", "Click Collect"],
columns: [
{type: 'text'},
{type: 'text'},
{type: 'numeric', numericFormat: { pattern: '0,0.00', culture: 'en-GB' }},
{type: 'text'},
{type: 'numeric', numericFormat: { pattern: '0,0.00', culture: 'en-GB' }},
{type: 'text'},
{type: 'numeric', numericFormat: { pattern: '0,0.00', culture: 'en-GB' }},
{type: 'text'},
],
columnSorting: {
sortEmptyCells:...