i trying read , insert excel file data mysql database table using angularjs( front and) , codeigniter (back end).thanks in advance
included xlsx-reader.js excel file read code not working.
html
<div ng-app="app"> <div ng-controller="previewcontroller"> <div class='form-group'> <label for='excel_file'>excel file</label> <button class="btn btn-link" type="file" ng-model="file"ngf-select ngf-change="importtoexcel()"> <span class="glyphicon glyphicon-share"></span>importexcel </button> </div> </div> </div> app.js
(function(undefined) { app.factory("xlsxreaderservice", ['$q', '$rootscope', function($q, $rootscope) { var service = function(data) { angular.extend(this, data); }; service.readfile = function(file, showpreview) { var deferred = $q.defer(); xlsxreader(file, showpreview, function(data){ $rootscope.$apply(function() { deferred.resolve(data); }); }); return deferred.promise; }; return service; } ]); }).call(this); controller.js
angular.module('app').controller('previewcontroller', function($scope, xlsxreaderservice) { $scope.showpreview = false; $scope.importtoexcel= function(files) { $scope.sheets = []; $scope.excelfile = file[0]; xlsxreaderservice.readfile($scope.excelfile, $scope.showpreview).then(function(xlsxdata) { $scope.sheets = xlsxdata.sheets; }); }; }
Comments
Post a Comment