How to implement Export to excel in angular 2

Question

Hello Friends,                  I have to implement export to excel in angular 2.Please share link related to this.   Thanks Amit Singh

Hardik Deshani · Answer

Try below link for export excel   https://atozsourcecode.com/BlogPost/Index/c01de640-f2b7-4d13-997e-df0c62de58b9/export-data-table-to-excel-file-using-npoi-dll-library-c-sharp   Hope this will help.

Maen Badwan · Answer

You can try using HTML5/JS Document Viewer control from LEADTOOLS with document conversion services. This control can be used with AngularJS 2 as shown in the following link:
https://www.leadtools.com/support/forum/posts/t12485-How-To--Use-the-Document-Viewer-in-an-Angular2-Application
Also you can directly try using the LEADTOOLS Cloud service for direct convert:
https://services.leadtools.com/documentation/tutorials
To export to Excel, you can use code similar to this at the server side: using  (var document = DocumentFactory.LoadFromStream(ms, options))   {       using  (DocumentConverter documentConverter =  new  DocumentConverter())      {         var outFile = @ "outFile.xlsx" ;         var format = DocumentFormat. Xls;         var jobData = DocumentConverterJobs.CreateJobData(document, outFile, format);         jobData.JobName =  "conversion job" ;         var job = documentConverter.Jobs.CreateJob(jobData);         documentConverter.Jobs.RunJob(job);      }   }

Muthu Kumar · Answer

Hai iam allready done before using some npm packages.   The followings steps are used to generate EXCEL.   Requirements:-   1.alasql 2.xlsx 3.xlsx-style   So we need to install above to npm package to your project.   1.https://www.npmjs.com/package/alasql 2.https://www.npmjs.com/package/xlsx 3.https://www.npmjs.com/package/xlsx-style   These are website used to refrence to install alasql, xlsx and xlsx-style   Installation Commands:-   1.alasql:-  npm install alasql –save   2.xlsx:- npm install xlsx–save   3.xlsx-style:- npm install xlsx-style --save   In our Project we need to confugure.The following steps are used to confugure   File Name:- angular-cli.json   Add the Following Lines,   "scripts": [ "../node_modules/alasql/dist/alasql.min.js", "../node_modules/xlsx/dist/xlsx.core.min.js", "../node_modules/xlsx-style/dist/xlsx.full.min.js" ],   Sample Coding:-   import { Component, OnInit } from '@angular/core'; import * as alasql from 'alasql'; export class ViewComponent implements OnInit { excel(){ var data1 = [ { a: 1, b: 10 }, { a: 2, b: 20 } ]; var data2 = [ { a: 100, b: 10 }, { a: 200, b: 20 } ]; var opts = [ { sheetid: 'One', header: true }, { sheetid: 'Two', header: false } ]; var res = alasql('SELECT INTO XLSX("Sample.xlsx",?) FROM ?', [opts, [data1,data2]]); } }   I hope its helpful to you. Thanks, Muthukumar

Sanwar Ranwa · Answer

Hello Amit   Check these links   https://www.npmjs.com/package/angular2-csv     https://www.npmjs.com/search?q=keywords:export-to-excel   https://github.com/ashishsantikari/excel-export-angular2