L

et's create an excel sheet dynamically and add data dynamically from array of objects. In this article, we'll learn how we can create an excel sheet dynamically in nodejs with given array.

Let's get started:

Prepare your array of JSON:

First, you need to prepare the data to create the excel sheet. Here we'll create a file with name data.json, and in this file, we'll keep our array of JSON. I have added some data in my file as:

data.json

                                [
                                {
                                "email": "abc@gmail.com",
                                "industry":"IT"
                                "role": "Developer",
                                "firstName": "Shubham",
                                "lastName": "Verma",
                                "title": "Software Engineer",
                                "country": "India"
                                },
                                {
                                "email": "XYG@gmail.com",
                                "industry":"IT"
                                "role": "Developer",
                                "firstName": "Ankit",
                                "lastName": "Kumar",
                                "title": "Software Engineer",
                                "country": "India"
                                }
                                ]
                    
                              

We'll create a sheet of the above data and we will add some conditions also. Based on the given condition, we will have the data in an excel sheet. Let's create a node server app.js for this demo and we will write our logic in this file.

app.js

                            const data = require('./data.json');
                            const fs = require('fs');
                            const _ = require('lodash');
                            const app = require('express')();
                            const json2xls = require('json2xls');
                            const filename = 'myExcel.xlsx';
                    
                            app.listen(5050, () => {
                                console.log("app is running on port 5050");
                             })
                    
                             const convert = function () {
                                const havingIndustry = _.filter(data, (usr) => {
                                    if (usr.industry) {
                                        // let industry = usr.industry.toLowerCase();
                                        let industry = usr.industry;
                                        return industry.match(/IT/i); // Case Insensitive
                                    }
                                });
                    
                                var xls = json2xls(havingIndustry);
                                fs.writeFileSync(filename, xls, 'binary', (err) => {
                                    if (err) {
                                        console.log("writeFileSync error :", err);
                                    }
                                    console.log("The file has been saved!");
                                });
                             }
                              
                             conver();
                          

Now we have written the logic to insert our data into the excel sheet with the name myExcel.xlsx.

Run the codes:

Now let run the above nodeJS code. To run the code execute the following commands in terminal/CMD after navigation on the app.js location.

npm install express fs json2xls lodash

After successful above run, run the below command:

node app.js

Congrats,Now you can see, your excel sheet will be created with the given name. Check your directory.