How to create an export to excel service using NodeJS and Express

Prerequisite

It would be expected that the reader has basic knowledge of NodeJS and ExpressJS since this read is more towards targeting a specific use case rather than an overview of Node and Express :)

Use case

It was a couple of months back when I was assigned with a mind-boggling task of creating an export to excel service for one of the applications in banking domain. It took us lot of research, struggle and perseverance to come up with the best library for achieving this, hence we thought of sharing this with the open source community.

Let’s lay down the basic requirements…


Excerpts from the Open MRS RFC by the Micro Frontend SQUAD.

Calculated decisions for architecting Micro Frontends
Calculated decisions for architecting Micro Frontends
Calculated decisions for architecting Micro Frontends

The Need for a Micro Frontends Rule book

It was one fine day when we were on a pursuit to research on well-established standards around Micro Frontends. One of the major reasons for the research was to lay down a foundation layer for our future work in order to create a complete, stable, civilized and production-ready Micro Frontends ecosystem.

After a couple of hits and misses, we landed on one of the RFCs on Micro Frontends curated by the OpenMRS team. Reading it thoroughly helped us realize that this is exactly what the doctor ordered and hence, we decided to reuse the efforts of the OpenMRS Micro Frontends…


Prerequisites

This blog requires you to have a theoretical understanding of what micro frontends are and why they even exist. In case the word micro frontend has hit your brain cells for the first time, I would request you to roll your brain over this video by Joel Denning.

A scenario, since we are humans

Imagine a micro frontend ecosystem wherein multiple Angular applications are combined into a single page to create a seamless user experience as demonstrated below.

Faizal Vasaya

Senior Web UI Developer at Globant and a bibliophile.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store