/** * 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 = [], styleList= []; var sheetsArr = rpt_xl_util.testWriteSheets(testReport07_1, sharedStrList, styleList); 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'); t.end(); });