Trying to output large xlsx files
-
Hi,
We have been trying to find a solution that would let us output a xlsx file with multiple tabs and sometimes approaching 1M rows on a tab or 2. We currently can reliable get output up to ~400k rows using the xlsx recipe and fetching the data as a large json blob from sql.
I have been trying to rework this to enable sql pagination and one of the builtin helpers to work with the paginated data, then flush the before in a before render function. So far I have been unsuccessful due to different errors. RIght now using an htmltoxlsx recipe the helper (htmlToXlsxEachRows) doesn't seem t take an async anonymous function that would paginate over the data. It appears that the function is never called. The synchronous function that returns the anon function is called.I am open to any suggestions about how to make this work. It seems all of the pieces are present, just not talking to each other to make it h appen.