Automate your reports using JavaScript

reportJsonExcel.ts

import path from 'path';

import util from 'util';
import fs from 'fs';

import * as XLSX from 'xlsx';

const writeFile = util.promisify(fs.writeFile);

const cwd = process.cwd();

export const reportJsonExcel = async (filename: string, data: any) => {
  const jsonFile = path.join(cwd, `${filename}.json`);
  const excelFile = path.join(cwd, `${filename}.xlsx`);

  // eslint-disable-next-line
  console.log(`report at: ${jsonFile}`);
  // eslint-disable-next-line
  console.log(`report at: ${excelFile}`);

  await writeFile(jsonFile, JSON.stringify(data, null, 2));

  const ws = XLSX.utils.json_to_sheet(data);
  const wb = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(wb, ws, 'Cohort');

  await XLSX.writeFile(wb, excelFile);
};