我们有一个情况,希望使用openpyxl为工作表的选项卡添加颜色。是否可以在库内完成此操作?或者,有没有人找到了在库外实现此操作的方法(例如通过扩展或类似方法)?
使用Python模块XlsxWriter可以在新的Excel文件中设置选项卡颜色。以下是一个例子:
from xlsxwriter.workbook import Workbook
workbook = Workbook('tab_colors.xlsx')
# Set up some worksheets.
worksheet1 = workbook.add_worksheet()
worksheet2 = workbook.add_worksheet()
worksheet3 = workbook.add_worksheet()
worksheet4 = workbook.add_worksheet()
# Set tab colours
worksheet1.set_tab_color('red')
worksheet2.set_tab_color('green')
worksheet3.set_tab_color('#FF9900') # Orange
# worksheet4 will have the default colour.
workbook.close()