StyleExcelHandler 给一个样例

下面是一个StyleExcelHandler类的样例实现：

import openpyxl
from openpyxl.styles import Font, Alignment

class StyleExcelHandler:
    def __init__(self, filename):
        self.filename = filename
        self.workbook = openpyxl.Workbook()
        self.sheet = self.workbook.active

    def set_cell_value(self, row, column, value):
        cell = self.sheet.cell(row=row, column=column)
        cell.value = value

    def set_cell_font(self, row, column, font_name, font_size, bold=False, italic=False):
        cell = self.sheet.cell(row=row, column=column)
        font = Font(name=font_name, size=font_size, bold=bold, italic=italic)
        cell.font = font

    def set_cell_alignment(self, row, column, horizontal, vertical):
        cell = self.sheet.cell(row=row, column=column)
        alignment = Alignment(horizontal=horizontal, vertical=vertical)
        cell.alignment = alignment

    def save(self):
        self.workbook.save(self.filename)

使用示例：

handler = StyleExcelHandler("example.xlsx")
handler.set_cell_value(1, 1, "Hello")
handler.set_cell_font(1, 1, "Arial", 12, bold=True)
handler.set_cell_alignment(1, 1, "center", "center")
handler.save()

以上代码创建了一个名为example.xlsx的Excel文件，并在第一行第一列写入了"Hello"，并设置了字体为Arial、大小为12、加粗，以及水平和垂直居中对齐。最后通过调用save方法保存文件