1. json2xls-worker-thread.git
  2. src
  3. util.js
 RSS Git Download  Clone
Raw View History
Blames found: 37 Mode: javascript Binary: false


Hang on, we reloading big blames...
 5fe31002
const nodeExcel = require('excel-export') const objectPath = require('object-path')
 07c75521
 5fe31002
const transform = function (json, config) { const conf = transform.prepareJson(json, config) const result = nodeExcel.execute(conf) return result }
 07c75521
 5fe31002
// get a xls type based on js type function getType (obj, type) {
 07c75521
if (type) {
 5fe31002
return type
 07c75521
}
 5fe31002
const t = typeof obj
 07c75521
switch (t) { case 'string': case 'number':
 5fe31002
return t
 07c75521
case 'boolean':
 5fe31002
return 'bool'
 07c75521
default:
 5fe31002
return 'string'
 07c75521
} }
 5fe31002
// get a nested property from a JSON object given its key, i.e 'a.b.c' function getByString (object, path) { path = path.replace(/\[(\w+)\]/g, '.$1') // convert indexes to properties path = path.replace(/^\./, '') // strip a leading dot const defaultValue = object[path] || null return objectPath.get(object, path, defaultValue)
 07c75521
}
 5fe31002
// prepare json to be in the correct format for excel-export transform.prepareJson = function (json, config) { const res = {} const conf = config || {} const jsonArr = [].concat(json) let fields = conf.fields || Object.keys(jsonArr[0] || {}) let types = []
 07c75521
if (!(fields instanceof Array)) {
 5fe31002
types = Object.keys(fields).map(function (key) { return fields[key] }) fields = Object.keys(fields)
 07c75521
}
 5fe31002
// cols res.cols = fields.map(function (key, i) {
 07c75521
return { caption: key,
 5fe31002
type: getType(jsonArr[0][key], types[i]), beforeCellWrite: function (row, cellData, eOpt) { eOpt.cellType = getType(cellData, types[i]) return cellData
 07c75521
}
 5fe31002
} }) // rows res.rows = jsonArr.map(function (row) { return fields.map(function (key) { let value = getByString(row, key) // stringify objects if (value && value.constructor === Object) value = JSON.stringify(value) // replace illegal xml characters with a square // see http://www.w3.org/TR/xml/#charsets // #x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x10000-#x10FFFF]
 07c75521
if (typeof value === 'string') {
 5fe31002
// eslint-disable-next-line no-control-regex value = value.replace(/[^\u0009\u000A\u000D\u0020-\uD7FF\uE000-\uFFFD\u10000-\u10FFFF]/g, '')
 07c75521
}
 5fe31002
return value }) }) // add style xml if given
 07c75521
if (conf.style) {
 5fe31002
res.stylesXmlFile = conf.style
 07c75521
}
 5fe31002
return res } /* transform.middleware = function (req, res, next) { res.xls = function (fn, data, config) { const xls = transform(data, config) res.setHeader('Content-Type', 'application/vnd.openxmlformats') res.setHeader('Content-Disposition', 'attachment filename=' + fn) res.end(xls, 'binary') } next() } */
 07c75521
 5fe31002
module.exports = transform