node package manager
Share your code. npm Orgs help your team discover, share, and reuse code. Create a free org ยป


Simple use

var excel_exporter = require('excel_exporter');

excel_exporter.export(datas, title, options, data_ref, res);

  • Where datas is an array that contents each data in the excel rows.
  • title is a string and is the file name of your .xlsx.
  • options specifies some export options.
  • data_ref selects and locates items in each element of the ** datas **, and gives name to each column of items.
  • res is the respond Object when using HTTP module in Node.js.


$ npm install excel_exporter


  • headless : do not generate header with data_ref


data_ref contents the items that you want to export in your .xlsx file, and looks like below:

      "map_value": "",
      "map_type": "order",
      "map_key": "Order"
      "map_value": "company_name",
      "map_type": "normal",
      "map_key": "Company"
      "map_value": "creator_nickname",
      "map_type": "normal",
      "map_key": "Creater"
      "map_value": ["created","modified"],
      "map_type": "normal",
      "map_key": "Created at/ Updated at"
  • map_value : is the referance in each element in your datas array, can be "" when map_type is "order". When map_type is "combine", map_value should be of Array type.
  • map_type : describes how this column data is formed, can be "order", "normal" or "combine".
  • map_key : is the name that you give to this column, affects headers.