ConstructionCost/test/unit/excel_export/rpt_excel_export_test.js

/**
 * Created by Tony on 2017/4/10.
 */
var test = require('tape');
var fs = require('fs');
var fsUtil = require('../../../public/fsUtil');
var rpt_xl_util = require('../../../modules/reports/util/rpt_excel_util');

test('check excel output', function(t){
    var data = fs.readFileSync('../../../tmp/07_1.page.js', 'utf8', 'r');
    eval(data);
    //console.log(testReport07_1);
    var sheets = [];
    for (var i = 0; i < testReport07_1.items.length; i++) {
        sheets.push({sheetName: '第' + (i + 1) + '页'});
    }
    var ct = rpt_xl_util.testWriteContentTypes(sheets);
    fsUtil.writeArrayToFile(ct, '../../../tmp/[Content_Types].xml');
    t.pass('pass content types');
    var rootRels = rpt_xl_util.testWriteRootRels();
    fsUtil.writeArrayToFile(rootRels, '../../../tmp/.rels');
    t.pass('pass root rels');
    var app = rpt_xl_util.testWriteApp(sheets);
    fsUtil.writeArrayToFile(app, '../../../tmp/app.xml');
    t.pass('pass app');
    var core = rpt_xl_util.testWriteCore(sheets);
    fsUtil.writeArrayToFile(core, '../../../tmp/core.xml');
    t.pass('pass core');
    var xlWBs = rpt_xl_util.testWriteXlWorkBook(sheets);
    fsUtil.writeArrayToFile(xlWBs, '../../../tmp/workbook.xml');
    t.pass('pass workbook');
    //workbook.xml.rels
    var xlRels = rpt_xl_util.testWriteXlRels(sheets);
    fsUtil.writeArrayToFile(xlRels, '../../../tmp/workbook.xml.rels');
    t.pass('pass xl sheet rels');
    var sharedStrList = [], stylesObj = {};
    var sheetsArr = rpt_xl_util.testWriteSheets(testReport07_1, sharedStrList, stylesObj);
    for (var i = 0; i < sheetsArr.length; i++) {
        fsUtil.writeArrayToFile(sheetsArr[i], '../../../tmp/sheet' + (i + 1) + '.xml');
        t.pass('pass sheet' + (i + 1));
    }
    var sharedStr = rpt_xl_util.testWriteSharedString(sharedStrList);
    fsUtil.writeArrayToFile(sharedStr, '../../../tmp/sharedStrings.xml');
    t.pass('pass shared string');

    var styleStr = rpt_xl_util.testWriteStyles(stylesObj);
    fsUtil.writeArrayToFile(sharedStr, '../../../tmp/styles.xml');
    t.pass('pass styles');

    var theme = rpt_xl_util.testWriteTheme();
    //console.log(theme);
    var themeArr = [];
    themeArr.push(theme)
    fsUtil.writeArrayToFile(themeArr, '../../../tmp/theme1.xml');
    t.pass('pass theme');
    t.end();
});