save a transpose JSON to excel sheet

user_12557235 0
Viewed 298

I am trying to make a transpose of JSON and save it to excel sheet:

function transpose(a) {
    return Object.keys(a[0]).map(function(c) {
        return a.map(function(r) { return r[c]; });
    });
}

//example for JSON (in the program I get a long JSON in this shape)
const sheet_arr = [{'param1': 1, 'param2': 2},{'param1': 3, 'param2': 4},{'param1': 5, 'param2': 6}] 
 
var temp_ws = xls.utils.json_to_sheet(transpose(sheet_arr));
wb.Sheets['test'] = temp_ws;

In the excel sheet I am getting:

 __________________
|  0  |  1  |  2  |
-------------------
|  1  |  3  |  5  | 
|  2  |  4  |  6  | 
-------------------

I Want to get this:

 _____________________________
|  param1  |  1  |  3  |  5  |
|  param2  |  2  |  4  |  6  |
------------------------------

how can I get it easily?

xlsx excel json javascript
1 Answers

This should get you the content you want:

function transpose(a) {
    return Object.keys(a[0]).map(function(c) {
      let ret=a.map(function(r) { return r[c]; });
      ret.unshift(c); return ret;
    });
};

// or in ES6 notation:
const transp = a => Object.keys(a[0]).map(c=>{
  let ret=a.map(r=>r[c]); ret.unshift(c); 
  return ret; });

//example for JSON (in the program I get a long JSON in this shape)
const sheet_arr = [{'param1': 1, 'param2': 2},{'param1': 3, 'param2': 4},{'param1': 5, 'param2': 6}] ;

console.log(transpose(sheet_arr));
console.log(transp(sheet_arr));
.as-console-wrapper {max-height:100% !important}

I simply add the key as the first element in each row, using Array.unshift().

user_26100610
Related