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

angular array export to excel

Ham-Solo answered on April 12, 2021 Popularity 7/10 Helpfulness 4/10

answer angular array export to excel

related export excel form angular array to excel

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: angular export-to-excel javascript

Link to this answer
Share Copy Link

Contributed on Apr 12 2021

Ham-Solo

0 Answers Avg Quality 2/10

Closely Related Answers

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: javascript excel angular export

Link to this answer
Share Copy Link

Contributed on Dec 07 2021

Tough Turtle

0 Answers Avg Quality 2/10

angular array export to excel

Contents

More Related Answers

angular array export to excel

Closely Related Answers

export excel form angular array to excel

Grepper

Documentation

Social

Legal

Contact

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