ptb-be/utils/excel.js

const XLSX = require('xlsx')

module.exports.to_excel = (
  table = [
    {
      SheetNames,
      data: [],
    },
  ]
) => {
  let wb = XLSX.utils.book_new()
  wb.Props = {
    Title: 'Laporan',
    Author: 'RISTEK DIKTI',
    CreatedDate: new Date(),
  }

  table.forEach((e) => {
    wb.SheetNames.push(e.SheetNames)
    wb.Sheets[e.SheetNames] = XLSX.utils.json_to_sheet(e.data)
  })

  return XLSX.write(wb, { type: 'buffer' })
}