xlsx2mysqldeprecated

Generating queries & import to mysql from xlsx files

Usage no npm install needed!

<script type="module">
  import xlsx2mysql from 'https://cdn.skypack.dev/xlsx2mysql';
</script>

A node module for generating queries & importing to mysql from excel files

Installation Instructions
Usage
Configuration
Demo
Support
Notes

From npm: npm install xlsx2mysql

Require module:
const excel2Mysql = require("xlsx2mysql");

To generating mysql import queries:
excel2Mysql.exportExcelToQuery(excelFile, config, sqlFile);

Go to folder demo and run: node demo.js, a query file will be generated from mission.xlsx.