@bychrisme/excel-to-mysql v1.0.0

Excel-MySQL

Small API to extract data on XLS file to generate SQL syntax and store in database.

Tech

• NodeJs
• Express
• ExcelJs
• MySQL

Installation

Clone repository

$ git clone https://github.com/bychrisme/excel-to-mysql.git <project_name>

Install the dependencies.

$ cd <project_name>
$ npm install 

Configure environments file and edit it with your database configuration

$ cp .env.example .env
$ nano .env

If you use Windows operating system make sure to move DB_SOCKET_PATH content in your .env file

$ DB_SOCKET_PATH=

Usage

Use postman to test api, you can also pass name in request to specify table name you want to create