xlsx wipes ability to set tab colors

[Dilemma1980]

I could not find the ability to set the color of worksheet tabs so I have been using excelize. Excelize does this fine but once I start performing other formatting with xlsx the colors do not remain. They go back to the default once I open the workbook.

What I tried:

• Setting color of tabs with excelize then formatting other things with xlsx
• format with xlsx first then setting tab colors with excelize next
• Saving excelize.DocProperties and excelize.WorkbookPropsOptions before change then applying what was saved after.

None of these approaches seem to work The only thing that works is setting the color of the tabs with excelize and doing nothing with xlsx.

I want to use xlsx because excelize is very slow when formatting columns, rows, cells, etc.

[github-actions]

Stale issue message