@@ -8,7 +8,9 @@ const runs = 3;
88await runProfiling ( 'huge xlsx file streams' , ( ) => {
99return new Promise ( ( resolve , reject ) => {
1010// Data taken from http://eforexcel.com/wp/downloads-18-sample-csv-files-data-sets-for-testing-sales/
11- const workbookReader = new ExcelJS . stream . xlsx . WorkbookReader ( './spec/integration/data/huge.xlsx' ) ;
11+ const workbookReader = new ExcelJS . stream . xlsx . WorkbookReader (
12+ './spec/integration/data/huge.xlsx'
13+ ) ;
1214workbookReader . read ( ) ;
1315
1416let worksheetCount = 0 ;
@@ -32,7 +34,9 @@ const runs = 3;
3234
3335await runProfiling ( 'huge xlsx file async iteration' , async ( ) => {
3436// Data taken from http://eforexcel.com/wp/downloads-18-sample-csv-files-data-sets-for-testing-sales/
35- const workbookReader = new ExcelJS . stream . xlsx . WorkbookReader ( 'spec/integration/data/huge.xlsx' ) ;
37+ const workbookReader = new ExcelJS . stream . xlsx . WorkbookReader (
38+ 'spec/integration/data/huge.xlsx'
39+ ) ;
3640let worksheetCount = 0 ;
3741let rowCount = 0 ;
3842for await ( const worksheetReader of workbookReader ) {
@@ -55,13 +59,21 @@ const runs = 3;
5559async function runProfiling ( name , run ) {
5660console . log ( '' ) ;
5761console . log ( '####################################################' ) ;
58- console . log ( `WARMUP: Current memory usage:${ currentMemoryUsage ( { runGarbageCollector :true } ) } MB` ) ;
62+ console . log (
63+ `WARMUP: Current memory usage:${ currentMemoryUsage ( { runGarbageCollector :true } ) } MB`
64+ ) ;
5965console . log ( `WARMUP:${ name } profiling started` ) ;
6066const warmupStartTime = Date . now ( ) ;
6167await run ( ) ;
6268console . log ( `WARMUP:${ name } profiling finished in${ Date . now ( ) - warmupStartTime } ms` ) ;
63- console . log ( `WARMUP: Current memory usage (before GC):${ currentMemoryUsage ( { runGarbageCollector :false } ) } MB` ) ;
64- console . log ( `WARMUP: Current memory usage (after GC):${ currentMemoryUsage ( { runGarbageCollector :true } ) } MB` ) ;
69+ console . log (
70+ `WARMUP: Current memory usage (before GC):${ currentMemoryUsage ( {
71+ runGarbageCollector :false ,
72+ } ) } MB`
73+ ) ;
74+ console . log (
75+ `WARMUP: Current memory usage (after GC):${ currentMemoryUsage ( { runGarbageCollector :true } ) } MB`
76+ ) ;
6577
6678for ( let i = 1 ; i <= runs ; i += 1 ) {
6779console . log ( '' ) ;
@@ -70,8 +82,16 @@ async function runProfiling(name, run) {
7082const startTime = Date . now ( ) ;
7183await run ( ) ; // eslint-disable-line no-await-in-loop
7284console . log ( `RUN${ i } :${ name } profiling finished in${ Date . now ( ) - startTime } ms` ) ;
73- console . log ( `RUN${ i } : Current memory usage (before GC):${ currentMemoryUsage ( { runGarbageCollector :false } ) } MB` ) ;
74- console . log ( `RUN${ i } : Current memory usage (after GC):${ currentMemoryUsage ( { runGarbageCollector :true } ) } MB` ) ;
85+ console . log (
86+ `RUN${ i } : Current memory usage (before GC):${ currentMemoryUsage ( {
87+ runGarbageCollector :false ,
88+ } ) } MB`
89+ ) ;
90+ console . log (
91+ `RUN${ i } : Current memory usage (after GC):${ currentMemoryUsage ( {
92+ runGarbageCollector :true ,
93+ } ) } MB`
94+ ) ;
7595}
7696}
7797