Search Posts

Category: export

Export and Import File: Back-end or Front-end?

I’m confused about doing exporting in the back-end or front-end. For example in export: Using Spring and JPA Get data (repository) return ModelAndView (controller) in csv format using super-csv But this approach(export to csv) can also be done in angularjs. Request data(service) using javascript or other available api. In my case I’m using only javascript. return json data converted to csv file. downloaded as text/csv. I’m a beginner in this exporting process. I searched on […]

Angular excel export

Here ,I am calling my node program and getting data from MYSQL and on click exporting in excel. $scope.exportToExcel=function(){ $http.get(“/getDetails”).then(function(response){ console.log(response.data) $scope.details = response.data[1].data; // here you will get data },function(res){ console.log(“Error”,res) //error occured }); $scope.exportToExcel=function(tableId){ // ex: ‘#my-table’ var exportHref=Excel.tableToExcel(tableId,’WireWorkbenchDataExport’); $timeout(function(){location.href=exportHref;},100); // trigger download } var myApp=angular.module(‘myApp’,[]); myApp.factory(‘Excel’,function($window){ var uri=’data:application/vnd.ms-excel;base64,’, template='<html xmlns:o=”urn:schemas-microsoft-com:office:office” xmlns:x=”urn:schemas-microsoft-com:office:excel” xmlns=”http://www.w3.org/TR/REC-html40″><head><!–[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]–></head><body><table>{table}</table></body></html>’, base64=function(s){return $window.btoa(unescape(encodeURIComponent(s)));}, format=function(s,c){return s.replace(/{(w+)}/g,function(m,p){return c[p];})}; return { tableToExcel:function(tableId,worksheetName){ var table=$(tableId), ctx={worksheet:worksheetName,table:table.html()}, href=uri+base64(format(template,ctx)); return href; } }; }) […]