rpt_excel_export_test.js 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  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 real function.', function(t){
  9. var data = fs.readFileSync('../../../tmp/07_1.page.js', 'utf8', 'r');
  10. //var data = fs.readFileSync('../../../tmp/08_2.page.js', 'utf8', 'r');
  11. eval(data);
  12. rpt_xl_util.exportExcel(testReport07_1, null);
  13. t.pass('pass exportExcel');
  14. t.end();
  15. });
  16. //test('check excel output', function(t){
  17. // var data = fs.readFileSync('../../../tmp/07_1.page.js', 'utf8', 'r');
  18. // eval(data);
  19. // //console.log(testReport07_1);
  20. // var sheets = [];
  21. // for (var i = 0; i < testReport07_1.items.length; i++) {
  22. // sheets.push({sheetName: '第' + (i + 1) + '页'});
  23. // }
  24. // var ct = rpt_xl_util.testWriteContentTypes(sheets);
  25. // fsUtil.writeArrayToFile(ct, '../../../tmp/[Content_Types].xml');
  26. // t.pass('pass content types');
  27. // var rootRels = rpt_xl_util.testWriteRootRels();
  28. // fsUtil.writeArrayToFile(rootRels, '../../../tmp/.rels');
  29. // t.pass('pass root rels');
  30. // var app = rpt_xl_util.testWriteApp(sheets);
  31. // fsUtil.writeArrayToFile(app, '../../../tmp/app.xml');
  32. // t.pass('pass app');
  33. // var core = rpt_xl_util.testWriteCore(sheets);
  34. // fsUtil.writeArrayToFile(core, '../../../tmp/core.xml');
  35. // t.pass('pass core');
  36. // var xlWBs = rpt_xl_util.testWriteXlWorkBook(sheets);
  37. // fsUtil.writeArrayToFile(xlWBs, '../../../tmp/workbook.xml');
  38. // t.pass('pass workbook');
  39. // //workbook.xml.rels
  40. // var xlRels = rpt_xl_util.testWriteXlRels(sheets);
  41. // fsUtil.writeArrayToFile(xlRels, '../../../tmp/workbook.xml.rels');
  42. // t.pass('pass xl sheet rels');
  43. // var sharedStrList = [], stylesObj = {};
  44. // var sheetsArr = rpt_xl_util.testWriteSheets(testReport07_1, sharedStrList, stylesObj);
  45. // for (var i = 0; i < sheetsArr.length; i++) {
  46. // fsUtil.writeArrayToFile(sheetsArr[i], '../../../tmp/sheet' + (i + 1) + '.xml');
  47. // t.pass('pass sheet' + (i + 1));
  48. // }
  49. // var sharedStr = rpt_xl_util.testWriteSharedString(sharedStrList);
  50. // fsUtil.writeArrayToFile(sharedStr, '../../../tmp/sharedStrings.xml');
  51. // t.pass('pass shared string');
  52. //
  53. // var styleStr = rpt_xl_util.testWriteStyles(stylesObj);
  54. // fsUtil.writeArrayToFile(styleStr, '../../../tmp/styles.xml');
  55. // t.pass('pass styles');
  56. //
  57. // var theme = rpt_xl_util.testWriteTheme();
  58. // //console.log(theme);
  59. // var themeArr = [];
  60. // themeArr.push(theme)
  61. // fsUtil.writeArrayToFile(themeArr, '../../../tmp/theme1.xml');
  62. // t.pass('pass theme');
  63. // t.end();
  64. //});