rpt_excel_export_test.js 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. /**
  2. * Created by Tony on 2017/4/10.
  3. */
  4. var test = require('tape');
  5. var fs = require('fs');
  6. var fsUtil = require('../../../public/fsUtil');
  7. var rpt_xl_util = require('../../../modules/reports/util/rpt_excel_util');
  8. test('check excel output', function(t){
  9. var data = fs.readFileSync('../../../tmp/07_1.page.js', 'utf8', 'r');
  10. eval(data);
  11. //console.log(testReport07_1);
  12. var sheets = [];
  13. for (var i = 0; i < testReport07_1.items.length; i++) {
  14. sheets.push({sheetName: '第' + (i + 1) + '页'});
  15. }
  16. var ct = rpt_xl_util.testWriteContentTypes(sheets);
  17. fsUtil.writeArrayToFile(ct, '../../../tmp/[Content_Types].xml');
  18. t.pass('pass content types');
  19. var rootRels = rpt_xl_util.testWriteRootRels();
  20. fsUtil.writeArrayToFile(rootRels, '../../../tmp/.rels');
  21. t.pass('pass root rels');
  22. var app = rpt_xl_util.testWriteApp(sheets);
  23. fsUtil.writeArrayToFile(app, '../../../tmp/app.xml');
  24. t.pass('pass app');
  25. var core = rpt_xl_util.testWriteCore(sheets);
  26. fsUtil.writeArrayToFile(core, '../../../tmp/core.xml');
  27. t.pass('pass core');
  28. var xlWBs = rpt_xl_util.testWriteXlWorkBook(sheets);
  29. fsUtil.writeArrayToFile(xlWBs, '../../../tmp/workbook.xml');
  30. t.pass('pass workbook');
  31. //workbook.xml.rels
  32. var xlRels = rpt_xl_util.testWriteXlRels(sheets);
  33. fsUtil.writeArrayToFile(xlRels, '../../../tmp/workbook.xml.rels');
  34. t.pass('pass xl sheet rels');
  35. var sharedStrList = [], styleList= [];
  36. var sheetsArr = rpt_xl_util.testWriteSheets(testReport07_1, sharedStrList, styleList);
  37. for (var i = 0; i < sheetsArr.length; i++) {
  38. fsUtil.writeArrayToFile(sheetsArr[i], '../../../tmp/sheet' + (i + 1) + '.xml');
  39. t.pass('pass sheet' + (i + 1));
  40. }
  41. var sharedStr = rpt_xl_util.testWriteSharedString(sharedStrList);
  42. fsUtil.writeArrayToFile(sharedStr, '../../../tmp/sharedStrings.xml');
  43. t.pass('pass shared string');
  44. t.end();
  45. });