Writing data with stream writer appears to interfer with schanging sheet properties and hiding columns

[usuallyvexed]

excelize 2.7.1 Golang 1.20.5

I finally have the streamwriter functionality writing data to a worksheet, what used to take minutes now takes milliseconds!

To finish my worksheet I need to set a couple of columns as hidden, set their "outlinelevels" to 1 and then lastly change the background color of the sheet's tab. I cannot. I have tried many different ways of accomplishing this, but have had no success. I have used these features in other worksheets without issue, but they were not using streamwriter. Any help and guidance would be appreciated if there is a workaround, otherwise this appears to be a bug.

Thank you.

[xuri]

Thanks for your feedback. This issue is related to issues #725, #777, #826, and #1489. The normal mode function and stream mode function can't be used mixed. Because the stream writer is used for writing an amount of data for a new worksheet, the existing row's outline, hidden columns, and other worksheet properties will be lost after you write cells with stream writer. I'll consider adding more functions for the stream writer, but stream writer functions won't be mapping with each normal mode function. Currently, if you need to modify or append cells with the existing worksheet, please use the normal mode functions.