Gulp: Call An Async Function Which Provides Its Own Callback From Within A Transform Function

I want to create a function for use in a pipe() call in Gulp that'll enable conversion of xlsx files to json. I had this working with NPM package 'excel-as-json' for gulp 3, howeve

Solution 1:

This problem is coming deep from the excel library. The end event should be finish.

Unsuccessful Try

I did the following, to install the modified excel.js:

rm -rf node_modules/excel
git clone https://github.com/bdbosman/excel.js node_modules/excel
cd node_modules/excel && npm i && cd ../..

This is not enough since the excel-as-json uses an old version of excel.

Either you have to modify the excel-as-json module, to use excel@1.0.0 (after the Pull Request is merged) or manually edit the file in node_modules. I will describe the second way here.

Temporary Solution

Edit the excel file after installing the modules.

I used:

sed -i "s/'end'/'finish'/g" node_modules/excel/excelParser.js

And then I ran:

$ gulp excel-to-jsoncsv
[19:48:21] Using gulpfile ~/so-question-gulp-async-function-call-xlsx/gulpfile.js
[19:48:21] Starting 'excel-to-jsoncsv'...
[19:48:21] Finished 'excel-to-jsoncsv' after 126 ms

And it apparently worked.