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

How to implement Export to excel in angular 2

Answers (4)