Nodejs RestAPIs Upload Download Multiple Excel Files to MySQL PostgreSQL – Multer, Sequelize ORM, Exceljs, Read excel file - loizenai/Nodejs-Tutorials GitHub Wiki

Tutorial Link: Nodejs RestAPIs Upload Download Multiple Excel Files to MySQL/PostgreSQL – Multer, Sequelize ORM, Exceljs, Read-excel-file

Nodejs RestAPIs Upload Download Multiple Excel Files to MySQL/PostgreSQL – Multer, Sequelize ORM, Exceljs, Read-excel-file

In the tutorial, I will introduce how to build a Nodejs/Express RestAPIs application to upload/import and download/extract data from multiple Excel files to MySQL or PostgreSQL database by:

  • Express is used to build Nodejs RestApis
  • Multer is used to upload/download Excel files
  • Sequelize ORM is used to manipulate data with MySQL/PostgreSQL
  • Exceljs is used to save data objects to Excel file
  • Read-excel-file is used to parse Excel file to data objects

Overview – Nodejs/Express Upload Download Excel Files

Architecture

PROJECT STRUCTURE

Nodejs Project Structure

RESULTS

Results

Tutorial Link

Nodejs RestAPIs Upload Download Multiple Excel Files to MySQL/PostgreSQL – Multer, Sequelize ORM, Exceljs, Read-excel-file

Related Posts

  1. Angular Nodejs Fullstack CRUD Application with MySQL/PostgreSQL – Angular 10-9-8 HttpClient + Nodejs Express, Sequelize ORM
  2. Nodejs/Express CSV Upload Download to MySQL/PostgreSQL – Multer, Fast-CSV, Json2Csv, Sequelize
  3. Build Nodejs CRUD Application with MySQL/PostgreSQL – Express RestAPIs + Ajax : Post/Get/Put/Delete Request