search

qax-os / excelize

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
https://xuri.me/excelize
BSD 3-Clause "New" or "Revised" License
17.62k stars 1.68k forks source link

StreamChunkSize(16MB) variable setting function #1927

Open kyungmun opened 2 weeks ago

kyungmun commented 2 weeks ago

When you use SetRow() in the stream method, you know the function of recording to a temporary file and emptying the buffer in the Sync() logic when the data length of the buffer is more than 16MB.

I would like to improve this size so that it can be set by the user rather than being fixed.

When using the Excel save function on a server with low memory specifications, if the data is larger than 16MB, the process may be killed while SetRowing the data due to insufficient memory.

It would be nice to improve the ChunkSize value so that it can be set variably.

kyungmun commented 2 weeks ago

It would be nice if it could be set from at least 1MB.