12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- /**
- * 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();
- });
|