Introduction

Nodejs與s3的版本 透過uuid與之溝通 有使用ES6 所以node版本要注意

Installation

npm install --save bitbucket:iiot_cloudteam/iiot-excel-middleware#nodejs-ver

Usage

匯出範例

透過exportOnly這個參數就不需要指定redis相關參數 (只有匯入需要)

options

escape

將所有的data都跑一次escape，預設false

view

用officeapp online開啟excel

var ExcelM = require('iiot-excel-middleware');

var excel = new ExcelM({
  exportOnly: true
})

var testJson = {
    "fileName": "hellworld",
    "data": {
        "sheet1": [{
            "name": "N1",
            "age": 15,
            "tag": "T1"
        }, {
            "name": "N2",
            "age": 16,
            "tag": "T2"
        }, {
            "name": "N3",
            "age": 17,
            "tag": "T3"
        }, {
            "name": "N4",
            "age": 18,
            "tag": "T4"
        }, {
            "name": "N5",
            "age": 19,
            "tag": "T5"
        }]
    }
}

excel.dlExcel(testJson, {"escape": false})
.then(function(result) {
  console.log(result);
});

匯入範例

匯入一定需要設定redis (這是與Tim service溝通的方式) 只有IIOT Cloud 環境才能Access

var ExcelM = require('iiot-excel-middleware');

var excel = new ExcelM({
  redis: '127.0.0.1'
})

excel.getJson('uuid-12345678')
.then(function(result) {
  console.log(result);
});

Functions

escape

清除資料中的Array以及Object，轉為string

var myData = {
  "name": "Kay",
  "tags": ["IIOT", "Cloud"]
}

excel.escape(myData);
--> {"name": "Kay", "tags": "IIOT,Cloud"}