Angular - Handsontable Autocomplete
HTML
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js"></script>
<script src="http://handsontable.github.io/ngHandsontable/bower_components/handsontable/dist/handsontable.full.js"></script>
<script src="http://handsontable.github.io/ngHandsontable/dist/ngHandsontable.js"></script>
<link rel="stylesheet" href="http://handsontable.github.io/handsontable/dist/handsontable.full.css">
<div ng-app="myApp">
<div ng-controller="homeController as homeCtrl">
<hot-table
hot-id="myTable"
settings="homeCtrl.htSettings"
row-headers="true"
min-spare-rows="1"
datarows="homeCtrl.data"
height="300"
width="700">
<hot-column data="Category" title="'Category'" type="'autocomplete'"></hot-column>
<hot-column data="other1" title="'Other 1'" type="'text'"></hot-column>
<hot-column data="other2" title="'Other 2'" type="'text'"></hot-column>
</hot-table>
</div>
</div>
JavaScript
/* Application */
var myApp = angular.module('myApp', ['ngHandsontable']);
myApp.controller('homeController', function ($scope, categoryService, hotRegisterer) {
// Define view model
var vm = this;
// HandsonTables settings
vm.htSettings = { contextMenu: ['row_above', 'row_below', 'remove_row'] };
vm.data=[{}];
vm.autocompleteData=[{}];
vm.getAutocompleteData = function(){
categoryService.getAll().then(function(data) {
var hot = hotRegisterer.getInstance('myTable');
var columns = hot.getSettings().columns;
// Change source type at first column
columns[0].source = data.map(function(item) {
return item.Description;
});
hot.updateSettings({columns: columns});
});
};
vm.getAutocompleteData();
});
myApp.service('categoryService', ['$http', function($http) {
return {
getAll: function () {
return $http.get('http://neltic.apphb.com/Api/CategoryTypes').then(function(response) { return response.data; });
}
}
}]);