https://grokonez.com/node-js/node-js-import-excel-file-to-mysql-using-read-excel-file-lib
Node.js Import Excel File to MySQL – using Read-Excel-File lib
In the tutorial, Grokonez shows how to import data from Excel File to MySQL with Node.js using Read-Excel-File
lib.
- We create a Node.js project as below structure:
- Excel File:
-> Results:
Init package.json
file by cmd: npm init
-> Then install mysql
& read-excel-file
libs:
$ npm install mysql
$ npm install read-excel-file
-> package.json
file:
{
"name": "nodejs-import-excel-file-to-mysql",
"version": "1.0.0",
"description": "Nodejs Import Excel File to MySQL with Read-Excel-File ",
"main": "index.js",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1"
},
"keywords": [
"Nodejs",
"MySQL",
"Excel",
"Read-Excel-File"
],
"author": "grokonez.com",
"license": "ISC",
"dependencies": {
"mysql": "^2.16.0",
"read-excel-file": "^2.0.7"
}
}
More at:
https://grokonez.com/node-js/node-js-import-excel-file-to-mysql-using-read-excel-file-lib
Node.js Import Excel File to MySQL – using Read-Excel-File lib
#nodejs #mysql #excel #read-excel-file