/xlsx-maker

Primary LanguageJavaScript

Welcome to xlsx-maker 👋

Version License: MIT

Install

npm install xlsx-maker

Usage

import json2xlsx from "xlsx-maker";

const mock = [
  {name: 'Alice', age: 16, gender: 'female', score: 95},
  {name: 'Bob', age: 18, gender: 'male', score: 83},
  // ...
]

json2xlsx({
  filename: 'example',
  data: mock,
  headers: ['name', 'age', 'gender', 'score', 'grade'],
  format: {
    grade: (row, key) => row.score > 90 ? 'A' : 'B' // just a example
  }
})

this will make example.xlsx

A B C D E
1 name age gender score grade
2 Alice 16 female 95 A
3 Bob 18 male 83 B
4 ...

Author

👤 render