def test_add_named_range(Workbook):
wb = Workbook()
new_sheet = wb.create_sheet()
named_range = DefinedName('test_nr')
named_range.value = "Sheet!A1"
wb.add_named_range(named_range)
named_ranges_list = wb.get_named_ranges()
assert named_range in named_ranges_list
red2gre = GradientFill(fill_type="linear", stop=("FF0000", "00FF00"))
b3.fill = red2gre
thin_side = Side(border_style="thin", color="000000")
double_side = Side(border_style="double", color="FF0000")
b2.border = Border(diagonal=thin_side, diagonalUp=True, diagonalDown=True)
ws.merge_cells("A1:C2")
ws["A1"].value = "FishC"
center_align = Alignment(horizontal="center", vertical="center")
ws["A1"].alighment = center_align
highlight = NamedStyle(name="highlight")
highlight.font = Font(bold=True, size=20)
highlight.alignment = Alignment(horizontal="center", vertical="center")
wb.add_named_range(highlight)
ws["A1"].style = highlight
ws["B5"].value = "LOVE"
ws["B5"].style = highlight
# -------------------------------------------------------------------------------------------
import openpyxl
import datetime
from openpyxl.styles.colors import RED, GREEN, BLUE, YELLOW
wb = openpyxl.Workbook()
ws = wb.active
# 自定义格式
ws["A1"] = 88.8
ws["A1"].number_format = "#,###.00鱼币"
