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鱼币"