mysql - import excel data to database in angularjs -


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