Default Handsontable Demo
HTML
<script src="http://handsontable.com/dist/jquery.handsontable.full.js"></script>
<link rel="stylesheet" href="http://handsontable.com/dist/jquery.handsontable.full.css">
<link rel="stylesheet" href="http://handsontable.com/demo/css/samples.css">
<h2></h2>
<div id="exampleGrid" class="dataTable"></div>
CSS
body {
background-color: white;
margin: 20px;
}
h2 {
margin: 20px 0;
}
JavaScript
var columnLabels = ["Model","Year", "Cost", "Attribute Group dd","Category dd","Sub Category dd", "Attribute Group af","Category af","Sub Category af"];
var columns = [{"type":"text"},{"type":"numeric"}, {"type":"numeric"}, {"type":"dropdown","source":["Accessories","Automation Systems","Furniture","Media Players"]},{"type":"dropdown","source":["","Antennas","Audio Racks","audio video cables"]},{"type": "dropdown", "source":["AIT","AIWA","AKAI"]}, {"type": "autocomplete", "strict": true,"filter": false,"source":["Accessories","Automation Systems","Furniture","Media Players"]},{"type": "autocomplete", "strict": true,"filter": false,"source":["","Antennas","Audio Racks","audio video cables"]},{"type": "autocomplete", "strict": true,"filter": false, "source":["AIT","AIWA","AKAI"]}];
var $container = $("#exampleGrid");
$container.handsontable({
columnSorting: true,
fixedColumnsLeft: 3,
autoWrapRow: true,
minRows: 100,
colHeaders: columnLabels,
columns: columns
})