import { Component } from '@angular/core';
import { environment } from '../../environments/environment';
import { ModalController } from '@ionic/angular';
import * as XLSX from 'xlsx';
@Component({
selector: 'app-exporttoexcel',
templateUrl: 'exporttoexcel.page.html',
styleUrls: ['exporttoexcel.page.scss'],
})
export class ExportToExcelPage {
data:any = [];
constructor(private modalCtrl: ModalController) {
this.data = [{ "id": "5001", "type": "None" },
{ "id": "5002", "type": "Glazed" },
{ "id": "5005", "type": "Sugar" },
{ "id": "5003", "type": "Chocolate" },
{ "id": "5004", "type": "Maple" }];
}
ngOnInit(){
}
ExportToExcel(){
this.getExcelReport()
}
async getExcelReport() {
var filename = "test";
const ws: XLSX.WorkSheet = XLSX.utils.json_to_sheet(this.data);
const wb: XLSX.WorkBook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, filename);
XLSX.writeFile(wb, filename + '.xlsx');
}
}
I want to export to excel.
tried with the above code & excel is not downloading in ionic 6 angular 14 app.
anything missed here. Pls help us.
Thanks in advance.