CODEWITHSUNDEEP
javascriptjsonnode.jsexcel
klonaway
klonaway

Reputation: 479

NodeJS : smart JSON conversion to Excel file

I'm working in NodeJS and I would like to export a JSON-format object to an Excel file.

I am well aware that there are (at least) three npm packages for that purpose, but so far none of these gave me the output I'm dreaming of.

Here is the javascript object I have :

var myObject = 
      {
        hashkey1 : {
          keyA : dataA1,
          keyB : dataB2
        }
        hashkey2 : {
          keyA : dataA2,
          keyB : dataB2
        }
      };

The .xls (or .xlsx)(or any spreadsheet format) of my dreams has one line for each hashkey. On each line : first column would be the hashkeyX, second column would be the dataAX, third column would be the dataBX.

Is it possible to achieve such a result using available tools, or do I have to code it from scratch ? Any advice to get anywhere near this result ?

Upvotes: 1

Views: 1730

Answers (1)

Aikon Mogwai
Aikon Mogwai

Reputation: 5225

You can write to csv (comma-separated values) text file without any additional library. This extension open in Excel by default.

var fs = require('fs');
var file = fs.createWriteStream('file.csv', {'flags': 'w', autoClose: true});
var result = '';
for (var hashkey in myObject) 
    result += hashkey + ';' + myObject[hashkey].keyA + ';' + myObject[hashkey].keyB + '\n';
file.write(result);

Upvotes: 3

Related Questions