You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
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.
The text was updated successfully, but these errors were encountered: