xlsx generator

main.js

const jszip = new require('jszip')
const zip = new jszip()
const fs = require('fs')
const csv = require('csvtojson')

const exec = async (templateFileName, sourceFileName) => {
  const data = fs.readFileSync(templateFileName)
  const content = await zip.loadAsync(data)
  const targetFile = 'xl/sharedStrings.xml'
  const doc = await content.files[targetFile].async('string')
  // replace some texts
  const jsonArray = await csv().fromFile(sourceFileName)
  for (idx in jsonArray) {
    let o = jsonArray[idx];
    // fix special values (ex. <>&'") : reference http://xml.silmaril.ie/specials.html
    for (a in o) o[a]=o[a]
      .replace(/&/g, "&amp;")
      .replace(/</g, "&lt;")
      .replace(/>/g, "&gt;")
      .replace(/"/g, "&quot;")
      .replace(/'/g, "&apos;");
    await zip.file(
      targetFile,
      doc
        .replace('{#id}', o.id)
        .replace('{#author_name}', o.author_name)
        .replace('{#created_at}', o.created_at)
        .replace('{#title}', o.title)
        .replace('{#input}', o.input)
        .replace('{#estimated_output}', o.estimated_output)
        .replace('{#actual_output}', o.actual_output)
        .replace('{#result}', o.result)
        .replace('{#tested_at}', o.tested_at)
        .replace('{#test_method}', o.test_method)
        .replace('{#test_result}', o.test_result),
    );
    await new Promise((resolve, reject) => {
      zip
        .generateNodeStream({ type: 'nodebuffer', streamFiles: true })
        .pipe(fs.createWriteStream(`output/TEST_REPORT_${o.id}.xlsx`))
        .on('finish', () => resolve())
    });
    console.log(`${o.id} done.`);
  }
}

exec(
  'Test Case Report_Template.xlsx',
  'Aquamarine Version Control List - test_cases_report.csv',
)

package.json

{
  "name": "testReportGenerator",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "start": "node main.js"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "dependencies": {
    "csv-parser": "^3.0.0",
    "csvtojson": "^2.0.10",
    "jszip": "^3.5.0"
  }
}