Nodejs Upload Excel files to MySQL/PostgreSQL – (Express RestAPI Upload/Import Download/Export Multiple Excel files)

Nodejs Upload Excel files to MySQL/PostgreSQL – (Express RestAPI Upload/Import Download/Export Multiple Excel files)

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
Related posts:


Continue reading “Nodejs Upload Excel files to MySQL/PostgreSQL – (Express RestAPI Upload/Import Download/Export Multiple Excel files)”

Node.js RestApi File Upload (Download) Multiple Files/Images to MySQL/PostgreSQL database – Multer + Sequelize + Ajax

In the tutorial, I will introduce how to create a “Node.js RestApi File Upload” (and Node.js Rest Api File Download) Application with Ajax client to upload/download single or multiple files/images to MySQL/PostgreSQL database with Sequelize engine an Multer middleware.

– We use Express framework to create a Nodejs RestAPIs.
– We use Multer middleware for uploading images/files to Nodejs server.
– We use Sequelize ORM to store file data to database MySQL/PostgreSQL.

Related posts:


Here is a to-do-list:

– I draw a full diagram architecture of Nodejs RestAPI Upload Files
– I configure Sequelize ORM and Multer for Uploading files
– I build Nodejs Express RestApi to upload/download files
– I implement fontend with Jquery Ajax RestAPI client.

Continue reading “Node.js RestApi File Upload (Download) Multiple Files/Images to MySQL/PostgreSQL database – Multer + Sequelize + Ajax”