node package manager

excel_exporter

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.

Installation

$ npm install excel_exporter

Options

  • headless : do not generate header with data_ref

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.