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 RestApisMulter
is used to upload/download Excel filesSequelize
ORM is used to manipulate data with MySQL/PostgreSQLExceljs
is used to save data objects to Excel fileRead-excel-file
is used to parse Excel file to data objects