Search Posts

Category: excel

How to write on XLSX file using Javascript Array

I need suggestion on how to make a XLSX file using (Javascript array or JSON) and Style Object. I am already using alasql for generating the XLS file. But on opening of that file some advisory message is coming (verify that the file is not corrupted…). The code i am using is $scope.items = [{name: “nikki”, sur: 1001, pos: ”, data5 : “FSSS SDFGFD “,data6 : 323}] var mystyle = { sheetid: ‘MyFile’, headers: true, […]

How to export same size images from html table to excel

I am facing some issues in exporting the image from html table. when I clicked on export button to download the html table as excel file. The downloaded xls file has different size of image. I want to export the images with the size as in the html table. I am using following code, please give suitable suggestions regarding the problem. any other suggestion are also helpful. <style> table,th,td { border:2px solid red; border-collapse:collapse; } […]

Export JSON data to Excel file using angularjs and nodejs

I am reading a excel worksheet in JSON format. I want the JSON data to be written on to another excel(.xlsx) file. I am using xlsx and file saver node package. this.excelToJsonSpecificColumns = function (workbook, sheetName, headers, startColRange, endColRange, callBack) { var data = ”; var err = ”; var spreadsheet = ”; var excelBuffer = ”; try { // read from a file var worksheet = workbook.Sheets[sheetName]; var range = excel.utils.decode_range(worksheet[‘!ref’]); range.s.c = startColRange; […]

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 […]