High CPU usage of writer buffer

[guosgbin]

Description

If the generated Excel file is relatively large, when calling the excelize.(*File).Write method, the CPU usage will be very high, resulting in CPU spikes. May I ask if there are any solutions?

Steps to reproduce the issue

I generated a 20MB file, but the CPU usage is relatively high， this is a flamegraph.

Describe the results you received

The main CPU usage is in flate.(*compressor).deflate, but I haven't found a more efficient writing API provided by excelize.

Describe the results you expected

I hope there is a more efficient API for writing, or other solutions.

Go version

1.22

Excelize version or commit ID

2.4.1

Environment

test Environment: MacOS

Validations

• Check that there isn't already an issue that reports the same bug to avoid creating a duplicate.
• The provided reproduction is a minimal reproducible example of the bug.

[xuri]

This library using Go std zip by default, and support custom ZIP writer since #2200, this feature will be released in next version. Please also reference issue #2199.