Breaking News: Grepper is joining You.com. Read the official announcement!

export excel form angular array to excel

Tough Turtle answered on April 12, 2021 Popularity 6/10 Helpfulness 3/10

answer export excel form angular array to excel

related angular array export to excel

export excel form angular array to excel

Comment

import { Injectable } from '@angular/core';
import * as FileSaver from 'file-saver';
import * as XLSX from 'xlsx';

const EXCEL_TYPE = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8';
const EXCEL_EXTENSION = '.xlsx';
@Injectable()
export class ExcelService {

constructor() { }

public exportAsExcelFile(json: any[], excelFileName: string): void {

    const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(json);

    const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['data'] };
    const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
    this.saveAsExcelFile(excelBuffer, excelFileName);
}

Popularity 6/10 Helpfulness 3/10 Language javascript

Source: stackoverflow.com

Tags: angular excel export javascript

Link to this answer
Share Copy Link

Contributed on Dec 07 2021

Tough Turtle

0 Answers Avg Quality 2/10

Closely Related Answers

angular array export to excel

Comment

//DOWNLOAD
  download(){
    var csvData = this.ConvertToCSV( this.data);
    var a = document.createElement("a");
    a.setAttribute('style', 'display:none;');
    document.body.appendChild(a);
    var blob = new Blob([csvData], { type: 'text/csv' });
    var url= window.URL.createObjectURL(blob);
    a.href = url;
    var x:Date = new Date();
    var link:string ="filename_" + x.getMonth() +  "_" +  x.getDay() + '.csv';
    a.download = link.toLocaleLowerCase();
    a.click();

  }


// convert Json to CSV data in Angular2
  ConvertToCSV(objArray) {
    var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
    var str = '';
    var row = "";

    for (var index in objArray[0]) {
        //Now convert each value to string and comma-separated
        row += index + ',';
    }
    row = row.slice(0, -1);
    //append Label row with line break
    str += row + '\r\n';

    for (var i = 0; i < array.length; i++) {
        var line = '';
        for (var index in array[i]) {
            if (line != '') line += ','

            line += array[i][index];
        }
        str += line + '\r\n';
    }
    return str;
  }

Popularity 7/10 Helpfulness 4/10 Language javascript

Source: stackoverflow.com

Tags: export-to-excel javascript angular export-to

Link to this answer
Share Copy Link

Contributed on Apr 12 2021

Ham-Solo

0 Answers Avg Quality 2/10

export excel form angular array to excel

Contents

More Related Answers

export excel form angular array to excel

Closely Related Answers

angular array export to excel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.