JavaScript, json to excel (exceljs)

Question

I have to maintain a code that do a weird and slow loops.

Currently it's looping in a while each object from a JSON like this one (example JSON):

[
  {
    ID: 1,
    NAME: 'A'
  }, {
    ID: 3,
    NAME: 'D'
  },{
    ID: 5,
    NAME: 'etc'
  }
]

And it's creating an excel file with exceljs library but as I said, with some loops that I consider really unnecesary.

The idea is to create an excel file like this:

ID | NAME
---------
1  |  A
3  |  D
5  |  etc

So I wonder if there's a direct way with exceljs or another Excel library for NodeJS to create a simple excel file from a JSON, where each key of the JSON be a header value, and each value of thos key: value pairs be the value of the cell in the excel?

3ximus · Accepted Answer · 2023-09-01 18:00:14Z

3

The previous answer by @davidhu doesn't work. You'll have to setup the columns before adding the rows as a JSON:

const workbook = new ExcelJS.Workbook();
const worksheet = workbook.addWorksheet('My Sheet');

worksheet.columns = [
  { letter: 'A', header: 'ID', key: 'ID' },
  { letter: 'B', header: 'NAME', key: 'NAME' },
];

const rows = [
  { ID: 1, NAME: 'A' },
  { ID: 3, NAME: 'D' },
  { ID: 5, NAME: 'etc' },
];

const newRows = worksheet.addRows(rows);

edited Sep 1, 2023 at 18:00

answered Sep 1, 2023 at 17:51

3ximus

4095 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

davidhu · Accepted Answer · 2022-07-28 05:27:49Z

0

Looks like you can just add the json array

const workbook = new ExcelJS.Workbook();
const worksheet = workbook.addWorksheet('My Sheet');

const rows = [
  {
    ID: 1,
    NAME: 'A'
  }, {
    ID: 3,
    NAME: 'D'
  },{
    ID: 5,
    NAME: 'etc'
  }
]

const newRows = worksheet.addRows(rows);

https://github.com/exceljs/exceljs#add-rows

answered Jul 28, 2022 at 5:27

davidhu

10.6k7 gold badges37 silver badges58 bronze badges

1 Comment

david raj Feb 8 at 18:59

The mapping is done based on column key mapping

Collectives™ on Stack Overflow

JavaScript, json to excel (exceljs)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related