How to export excel from Angular 8 with headers from string array

Question

I want to export an excel file from my angular project. Headers of excel should be taken from a string array which looks like:

excelHeaders:string[] = ["Name","Age","Email","Contact Number","Location"];

Excel file will have only headers without any other data.

Please help.

give more details like what is component code and template code which library using for this. — Avinash Dalvi
– Avinash Dalvi, Commented Dec 17, 2019 at 5:12
please check this answer : stackoverflow.com/questions/58926366/… — Joel Joseph
– Joel Joseph, Commented Dec 17, 2019 at 5:14
Have you checked stackoverflow.com/questions/333537/… The GitHub repo URL - github.com/agershun/alasql — Sujit Kumar Singh
– Sujit Kumar Singh, Commented Dec 17, 2019 at 6:10

Abhi · Accepted Answer · 2019-12-17 06:23:15Z

2

Well, this xlsx documentation helped me to solve the question. XLSX

import * as XLSX from 'xlsx';  
...

excelHeaders:string[] = ["Name","Age","Email","Contact Number","Location"];
templateToExcel:string[][] = [this.excelHeaders,[]];

...

exportTemplateAsExcel()
{
const ws: XLSX.WorkSheet=XLSX.utils.aoa_to_sheet(this.templateToExcel);
const wb: XLSX.WorkBook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
XLSX.writeFile(wb,"test"+".xlsx");
}

answered Dec 17, 2019 at 6:23

Abhi

7142 gold badges15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Spandan · Accepted Answer · 2019-12-17 05:39:21Z

0

You can use any of the client side excel generation libs via npm like - XLSX, XLSX-Style, ExcelJS.

Each of them has well defined set of methods to generate the workbook and inside the workbook creating the rows, header-rows etc. For example while using excel-js -

excelHeaders:string[] = ["Name","Age","Email","Contact Number","Location"];

let workbook = new Workbook();
let worksheet = workbook.addWorksheet('Test Sheet');

let headerRow = worksheet.addRow(excelHeaders);

answered Dec 17, 2019 at 5:39

Spandan

2591 silver badge4 bronze badges

Collectives™ on Stack Overflow

How to export excel from Angular 8 with headers from string array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related