Now with Partition Management
    Share your code. npm Orgs help your team discover, share, and reuse code. Create a free org »

    iiot-excel-modulepublic

    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"}

    Keywords

    none

    install

    npm i iiot-excel-module

    Downloadslast 7 days

    1

    version

    1.0.1

    license

    ISC

    last publish

    collaborators

    • avatar