using mssql stream and no function available

[parifuture]

I am using using the mssql connector in node and have the stream option enabled. The reason being the record set getting returned is big (more than 60K) and I want the whole process of generating the excel consume less memory on the server and create the excel a little faster.

Now when calling the template.substitute function it basically removes the placeholders and then all the rows that are returned from the stream are not populated in the final excel output. I was wondering if there is a function which will allow to do so. Until then the workaround that I have is keep the adding the placeholder back in the excel until the last row is retrieved.

lmk if you need more info.