Skip to main content

Create a multi column csv report in nodejs without external library.


Recently I had a requirement to create a CSV report with multiple columns(merging two or more reports) in a single CSV file, but I didn't find any particular library(Maybe I didn't search properly) but found this solution. 

So let's begin with code that is self-explanatory.

const fs = require('fs');
const _file = `Agent_Customer_Report.csv`

//Report 1
const header1=['Customer Name','DOB','City','Pincode'];
const field1=['custName','dob','city','pincode'];
const report1Data=
[{'custName':"ABHISHEK",'dob':'01/23/1992','pincode':'443221','city':"Mumbai"}{'custName':"PUNIT",'dob':'01/23/1992','pincode':'443221','city':"Mumbai"}]

//Report2
const header2=['Agent Name','DOB','City','Pincode'];
const field2=['agentName','dob','city','pincode'];
const report2Data=
[{'agentName':"AGENT001",'dob':'01/23/1992','pincode':'443221','city':"Mumbai"},
{'agentName':"AGENT002",'dob':'01/23/1992','pincode':'443221','city':"Mumbai"}]

const replacer = (key, value) => value === null ? '' : value; // specify how you want to handle null values here

let record1 = report1Data.map(row => field1.map(fieldName => JSON.stringify(row[fieldName], replacer)).join(','));

let record2 = report2Data.map(row => field2.map(fieldName => JSON.stringify(row[fieldName], replacer)).join(','));

//Logic Part
record1.unshift(header1.join(','));
record1.unshift(["Customer  Report"].join(','));
record1.unshift(["  "].join(','));
record1.unshift(record2.join('\r\n'));
record1.unshift(header2.join(','));
record1.unshift(["Agent  Report"].join(','));

let csvArray = record1.join('\r\n');

fs.writeFileSync(_file, csvArray)
In this way, you can add more such headers and can merge many reports into a single csv.

I hope you like this article. Please stay connected for more such articles.

You can also follow me on Twitter or Linkedin for the latest updates.

Written By:

Saurabh Joshi


Comments

Post a Comment

Popular posts from this blog

Coding Interview Questions Set 1

From this article, I will be sharing with you all a series of articles on coding interview questions. So please stay connected for the latest set of questions. It will be a good brainstorming exercise and will also prepare you for coding interviews and will definitely boost your confidence. So let's start, 1)Reverse of a string with only O(1) extra memory. Solution: var reverse = function(string) {     let result = ''     for(let i= string.length -1; i >= 0; i--){         result += string[i];     }     return result; }; 2)Fizz Buzz: Write a program that will accept a number n and will output number till n but for multiples of three it should output “Fizz” instead of the number and for the multiples of five output “Buzz”. For numbers which are multiples of both three and five output “FizzBuzz”. Solution: var fizzBuzz= function(n) {     const arr=[]     for(i=1; i<=n; i++){ ...
9 comments
Read more

JavaScript: Debouncing | Flipkart UI Interview Question.

To understand this programming practice will go with a quick example. We all do online shopping and we do search for products on Flipkart on the search bar. So when we type on search bar i.e on every keypress we are actually giving API requests to the server, which in response gives us suggestions. Actually, it's a time-consuming task and may degrade the performance of the webpage. So to improve the performance we use debounce function which actually acts as a controller which reduces the API request to the server on keypress event. In simple terms, we are giving API request only after a certain amount of time between two keypress events. A debounce is a higher-order function. Higher-order function: A function that returns another function. Let's dive deep: HTML Code: <input type="text" onkeyup="searchProducts()"/> Consider this as a search bar for Flipkart. On any keypress, we are calling searchProducts() function. Javascri...
Post a Comment
Read more

Node.js: Bundling your Node.js application to single executable for Windows.

In this article, we will see how to bundle Node.js application to a single executable for Windows. What's the need? Well recently, I had taken a work where I needed to convert pdf's(Of similar format) to excel sheet. So I was reading the pdf's from a folder in desktop and I was storing the output excel sheet into a separate folder on the desktop. I used Node.js for the program. Now the client wanted it to install the program on 25 windows machine and his budget was really low. So it was also not possible for me to install node.js for 25 machines and then install the required dependency for each one. One of the solution: While I was searching for an easy solution I found this amazing npm module pkg . This module can make your node.js app work like plug and play type. No need to install Node.js on the client machine or any other dependency.  It helps to make a commercial or trial version of your node.js application without exposing the source code. I found ...
Post a Comment
Read more