Search Posts

Category: excel

NPOI Excel file download corrupt

I am trying to export data from a data table to excel using NPOI, angular2 and web API. The steps I am following are – 1. Write data from data table to XLSX and store the file temporarily on the server, 2. Read this same and into a memory stream and return. I see that browser prompts the user to download the file, once the file is downloading I get an error saying the file […]

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; } }; }) […]

Excel data extraction using SheetJS/js-xlsx and its usage in AngularJS

I want to extract xlsx data and display onto my webpage. I have used SheetJS/js-xlsx for extraction of data from XL sheet. Data is successfully getting extraced but I am not sure how to get this data into AngularJS for further usage. /* set up XMLHttpRequest */ var url = “test.xlsx”; var oReq = new XMLHttpRequest(); oReq.open(“GET”, url, true); oReq.responseType = “arraybuffer”; oReq.onload = function(e) { var arraybuffer = oReq.response; /* convert data to binary […]