[Proposal] The paginator

[Siemienik]

The paginator

I want to propose add possibility to paginate result into xlsx-import, I suppose that should improve performance for larger files. I have no idea how it should be done yet, but this issue is only a proposition. So any ideas are welcome 🤗

Current:

Function getAllItems return all items from imported worksheet

https://github.com/Siemienik/xlsx-import/blob/4c74089/src/Importer.ts#L11-L17

After:

const importer = new PaginatedImporter(workbook);

 importer.getItems(cfg, 0, 100); // 1s "page": {offset:0, amount: 100}

 importer.getItems(cfg, 4*100, 100); // 5th "page": {offset:400, amount: 100}

Possible problems

Afaik, ExcelJS hasn't option to stop and resume function ws.eachRow. We use this function in verticalListStrategy. (probably resolved by: #80)

[Siemienik]

As described in The Index of Proposals (#144), it will be reopened if accepted.

🗣️ 🗣️ 🗣️ 🗣️ Any discussion here is wanted.