excel2mysql.js
A node module for generating queries & importing to mysql from excel files
Table of Contents
Installation Instructions
Usage
Configuration
Demo
Support
Notes
Installation-instructions
From npm: npm install xlsx2mysql
Usage
Require module:
const excel2Mysql = require("xlsx2mysql");
To generating mysql import queries:
excel2Mysql.exportExcelToQuery(excelFile, config, sqlFile);
Configuration
Demo
Go to folder demo and run: node demo.js
, a query file will be generated from mission.xlsx.