Streaming Read?

[pwalsh]

Hi, from the documentation, it is not clear (to me). Does this lib support streaming reads of sheets in an Excel workbook? I want to work with potentially huge sheets of data without loading all into memory.

[MrHubble]

@pwalsh can you please share some sample code for how you implemented this?

[pwalsh]

@MrHubble I didn't implement. I'm looking for a Node lib that does, hence my question.

[alangunning]

@pwalsh @MrHubble Did you figure out how to stream read sheets?

[pwalsh]

@alangunning no, did not look at it yet.

[MrHubble]

@alangunning no, I didn't implement streaming with exceljs either. For now I have restricted the amount of rows my user can import to 1,000 and continue to use https://github.com/SheetJS/js-xlsx

I would prefer to stream with exceljs in the future. Please post your solution if you are successful.

[guyonroche]

I'm still working on streaming reads. I ran into a problem with memory for very large sheets. Most likely will have to solve this with the aid of a /tmp folder. I will post here when ready

[alangunning]

Thank you. Your response and efforts are much appreciated.
Alan

[pwalsh]

@guyonroche very happy to review anything you have, when you are ready.

@rgrp you might want to follow this.