Write Performance

[duke-git]

使用write方法写入gin返回给前端，非常慢，截图是文件大小70M，用了41s. 请问有什么优化方法吗？
// file -> *excelize.File, c -> *gin.Context
_ = file.Write(c.Writer)

[duke-git]

[xuri]

Can you show us a complete, standalone example program or reproducible demo? And provide your input file, or at least tell us about it?

[duke-git]

我写一个实际业务的模拟方法，请参考截图：file.Write(c.Writer)，70M文件要写入40s左右。

[xuri]

Thanks for your feedback, please using stream writer for generating a new worksheet with huge amounts of data, and also reference the performance benchmark report.

[duke-git]

好的，用的是这个库：github.com/360EntSecGroup-Skylar/excelize/v2 v2.3.2， 和 github.com/xuri/excelize/v2 是同一个吗？

[xuri]

Yep, please using github.com/xuri/excelize/v2, and also reference the issues #973, #1020, and #1079.

[duke-git]

谢谢