from openpyxl import Workbook
from openpyxl.styles import Font, Border,Side, Alignment
from openpyxl.utils import get_column_letter

def create_solder_paste_label():
    # 创建新的工作簿
    wb = Workbook()
    ws = wb.active
    ws.title = "Sheet1"

    # 设置打印区域为A1:C6
    ws.print_area = 'A1:D7'

    # 定义边框样式
    thin_border = Border(
        left=Side(style='thin'),
        right=Side(style='thin'),
        top=Side(style='thin'),
        bottom=Side(style='thin')
    )

    # 设置列宽
    ws.column_dimensions['A'].width = 10.97894737
    ws.column_dimensions['B'].width = 10.01052632
    ws.column_dimensions['C'].width = 10.97894737
    ws.column_dimensions['D'].width = 10.01052632

    # 设置行高
    ws.row_dimensions[1].height = 17
    ws.row_dimensions[7].height = 48
    for row in range(2, 7):
        ws.row_dimensions[row].height = 17

    # 填充数据并设置样式
    # 第一行：锡膏标识卡
    ws['A1'] = '锡膏标识卡'
    # 合并A1:C1单元格
    ws.merge_cells('A1:D1')
    # 设置字体（大号、加粗）
    ws['A1'].font = Font(name='宋体', size=11, bold=True)
    ws['A1'].alignment = Alignment(horizontal='center', vertical='center')
    ws.merge_cells('B7:D7')
    # 第二行：料号和编号
    ws['A2'] = '料号'
    # 合并A2:B2单元格
    ws.merge_cells('A2:B2')
    # 设置字体（大号、加粗）
    ws['A2'].font = Font(name='宋体', size=11)
    ws['A2'].alignment = Alignment(horizontal='center', vertical='center')
    # 合并C2:D2单元格
    ws.merge_cells('C2:D2')
    # 设置字体（大号、加粗）
    ws['C2'].font = Font(name='宋体', size=11)
    ws['C2'].alignment = Alignment(horizontal='center', vertical='center')
    ws['C2'] = '49901.0001'
    ws['A2'].font = Font(name='宋体', size=11)
    ws['C2'].font = Font(name='宋体', size=11)
    ws['A2'].alignment = Alignment(horizontal='center', vertical='center')
    ws['C2'].alignment = Alignment(horizontal='center', vertical='center')

    # 第三行：第一次使用和第二次使用
    ws['A3'] = '第一次使用'
    ws['C3'] = '第二次使用'
    ws['A3'].font = Font(name='宋体', size=11)
    ws['C3'].font = Font(name='宋体', size=11)
    ws['A3'].alignment = Alignment(horizontal='center', vertical='center')
    ws['C3'].alignment = Alignment(horizontal='center', vertical='center')

    # 第四行：解冻时间标题
    ws['A4'] = '解冻时间'
    ws['C4'] = '解冻时间'
    ws['A4'].font = Font(name='宋体', size=11)
    ws['C4'].font = Font(name='宋体', size=11)
    ws['A4'].alignment = Alignment(horizontal='center', vertical='center')
    ws['C4'].alignment = Alignment(horizontal='center', vertical='center')

    # 第五行：搅拌时间标题
    ws['A5'] = '搅拌时间'
    ws['C5'] = '搅拌时间'
    ws['A5'].font = Font(name='宋体', size=11)
    ws['C5'].font = Font(name='宋体', size=11)
    ws['A5'].alignment = Alignment(horizontal='center', vertical='center')
    ws['C5'].alignment = Alignment(horizontal='center', vertical='center')

    # 第六行：开瓶时间标题
    ws['A6'] = '开瓶时间'
    ws['C6'] = '开瓶时间'
    ws['A6'].font = Font(name='宋体', size=11)
    ws['C6'].font = Font(name='宋体', size=11)
    ws['A6'].alignment = Alignment(horizontal='center', vertical='center')
    ws['C6'].alignment = Alignment(horizontal='center', vertical='center')


    # 为所有单元格添加边框
    for row in ws.iter_rows(min_row=1, max_row=7, min_col=1, max_col=4):
        for cell in row:
            cell.border = thin_border

    # 保存文件
    filename = '锡膏标签模板.xlsx'
    wb.save(filename)
    print(f"文件 '{filename}' 已创建成功！")
    print(f"打印区域已设置为: A1:D7")
    print(f"字体使用: 宋体")
    print(f"标题字体大小: 11pt")
    print(f"内容字体大小: 11pt")

if __name__ == "__main__":
    create_solder_paste_label()