Read file xlsx and convert to script sql

index.js

const xlsxFile = require('read-excel-file/node');
const fs = require('fs');

(async () => {
  const xlsx = await xlsxFile('./file.xlsx');
  const data = xlsx.slice(1);
  const nameTable = 'demo.tableX';

  save(`INSERT INTO ${nameTable} VALUES \n`);

  data.forEach((row) => {
    const values = row
      .map((value) => {
        try {
          var date = new Date(value);
          return `'${date.toISOString().slice(0, 19).replace('T', ' ')}'`;
        } catch (error) {}

        if (typeof value === 'string') {
          return `'${value}'`;
        }

        if (typeof value === 'number') {
          return value;
        }

        if (typeof value === 'boolean') {
          return value ? 1 : 0;
        }

        if (value === null || value === undefined) {
          return 'NULL';
        }

        return value;
      })
      .join(', ');

    save(`(${values}),`);
    save('\n');
  });

  console.log('Success');
})();

function save(content) {
  fs.appendFileSync('script.sql', content);
}