XLSX

Description

what is it ? : utility library to export data to Excel format.
URL : official NPM Repository
version : 0.18.5
Why ? :

Lightweight and simple .
Offers both CSV and Excel Exports

Application

example :


// let's import the library
import * as XLSX from 'xlsx';
data = [
  {
    firstName: 'John',
    lastName: 'Doe',
  },
  {
    firstName: 'Alice',
    lastName: 'Lee',
  },
];
// create a sheet
const ws = XLSX.utils.json_to_sheet(data);
// create workbook
const wb = XLSX.utils.book_new();
// add the sheet to the workbook
XLSX.utils.book_append_sheet(wb, ws, 'Responses');
// generate the file
XLSX.writeFile(wb, 'sampleData.export.xlsx');