xlsx2mysql v1.0.1

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.

Support

Notes