how to write all array elements to excel file using exceljs in nodejs

Question

I have a problem.. I want to write all array elements to excel file using exceljs in nodejs.. For example;

My array is like this array image

and than I want to write excel file. For example excel image

So how can I do this just like that.? Thanks for help..

have you ever looked the documentation of `exceljs`? There are lots of example; https://github.com/guyonroche/exceljs and https://www.npmjs.com/package/exceljs — mmu36478, Jan 25 '17 at 08:25

score 0 · Answer 1 · answered Jan 25 '17 at 08:31

For such kind of requirements where you have to put the array of data into Excel or CSV file, I have used fast-csv in my case so I am writing code for that. Hope this will helps you. .

You can use the following code:

var fs  = require('fs'); // using npm install fs module on application
var csv = require("fast-csv"); // I used this module in my case

var csvFileName = 'path of folder/file.csv'; 
var stream = fs.createReadStream(csvFileName); //reads the file
var headings = [];
var full = [];

headings.push('head1','head2','head3');

full.push(headings);

var csvStream = csv.createWriteStream({headers: true}),
           ws = fs.createWriteStream(file_location);

csv.write(full, {headers: true}).pipe(ws);
ws.on("finish", function(){
 response.redirect('/enriched'); // response is response parameter of your callback function
 // redirect where you wants
});

how to write all array elements to excel file using exceljs in nodejs

1 Answers1