Tag: rest api

Node.js Download Excel file example with exceljs

bezkoder 9 Comments

The Excel file is a spreadsheet file format created by Microsoft for use with Microsoft Excel. You can use the file to create, view, edit, analyze data, charts, budgets and more. In this tutorial, I will show you how to use Node.js Express Rest API to download Excel file from a table in MySQL Database using exceljs.

Related Posts:
– Node.js: Upload/Import Excel file data into Database
– Export MySQL data to CSV file using Node.js
– Export PostgreSQL data to CSV file using Node.js
– Export MongoDB collection to CSV file using Node.js

Download CSV File instead:
Node.js Download CSV file example

Read More

Node.js: Upload/Import Excel file data into Database

bezkoder 6 Comments

The Excel file is a spreadsheet file format created by Microsoft for use with Microsoft Excel. You can use the file to create, view, edit, analyse data, charts, budgets and more. In this tutorial, I will show you how to upload/import Excel file data into MySQL Database using Node.js & read-excel-file.

Related Posts:
– Upload/store images in MySQL using Node.js, Express & Multer
– How to upload/store images in MongoDB using Node.js, Express & Multer
– Import CSV data into MySQL using Node.js
– Import CSV data into PostgreSQL using Node.js
– Import CSV file into MongoDB collection using Node.js

CSV file instead:
Node.js: Upload CSV file data into Database with Express

Read More

How to Integrate Angular 8 with Node.js Restful Services

bezkoder 1 Comment

In this tutorial, I will show you step by step to integrate Angular 8 project with Node.js Restful Services so that we only need to run both on same Server/Port. You will also know how to configure Angular SPA Routing to avoid 404 on refresh.

Related Posts:
– Angular 8 + Node.js Express + MySQL example
– Angular 8 + Node.js Express + PostgreSQL example
– Angular 8 + Node.js Express + MongoDB example
– Node.js Express + Angular 8: JWT Authentication & Authorization example
– Angular 8 upload file/image to Node.js Server example

Newer versions:
– Integrate Angular 11/10 with Node.js Restful Services
– Integrate Angular 15/14/13/12 with Node.js Restful Services

Read More

Spring Boot MongoDB Pagination example with Spring Data

bezkoder 4 Comments

In previous post, we’ve known how to build Spring Boot Rest CRUD Apis with Spring Data MongoDB. In this tutorial, I will continue to make Pagination (and Filter) with Spring Data MongoDB and Pageable.

Related Post:
– Spring Boot MongoDB CRUD example
– Spring Boot @ControllerAdvice & @ExceptionHandler example

More Practice:
– Spring Boot, MongoDB: JWT Authentication with Spring Security
– Spring Boot Unit Test for Rest Controller
– Documentation: Spring Boot Swagger 3 example
– Caching: Spring Boot Redis Cache example
– Validation: Validate Request Body in Spring Boot
– Dockerize: Docker Compose: MongoDB and Spring Boot example

Clients for this Server:
– React with Material-UI / React with react-table v7
– Angular 8 / Angular 10 / Angular 11 / Angular 12 / Angular 13 / Angular 14 / Angular 15
– Vue with Bootstrap / Vuetify

Read More

Angular 8 + Node.js Express + PostgreSQL example: Build CRUD Application

bezkoder 9 Comments

In this tutorial, I will show you how to build a full-stack (Angular 8 + Node.js + Express + PostgreSQL) example with a CRUD Application. The back-end server uses Node.js + Express for REST APIs, front-end side is an Angular App with HTTPClient.

Newer versions:
– Angular 10 + Node.js Express + PostgreSQL example
– Angular 11 + Node.js Express + PostgreSQL example
– Angular 12 + Node.js Express + PostgreSQL example
– Angular 13 + Node.js Express + PostgreSQL example
– Angular 14 + Node.js Express + PostgreSQL example
– Angular 15 + Node.js Express + PostgreSQL example
– Angular 16 + Node.js Express + PostgreSQL example

More Practice:
– Node.js Express + Angular 8: JWT Authentication & Authorization example
– Angular 8 upload file/image to Node.js Server example

Run both projects in one place:
How to Integrate Angular 8 with Node.js Restful Services

Read More