Generate a worksheet with huge amounts of data

[ahKevinXy]

目前 生成 一个大的50万的数据excel 需要非常长的时间

[ahKevinXy]

发现到了11万以后就非常的慢

[xuri]

This similar with issue #1220. Which version of Excelize are you using? How many columns and rows in your data? How many characters of each cell average? And how many time cost? Can you show us a complete, standalone example program or reproducible demo? The library has been provided streaming API to generating or reading data from a worksheet with huge amounts of data. Please using the stream API if you can, and here are some performance figures for your reference: Performance Figures.

[ahKevinXy]

发现在 2万条数据以后生成 就非常慢 ,一秒在 几百的生成

excelFile.SetSheetRow("Sheet1", rowStartCell, &exportDataItem)