下面这些我实在懒得整理了，直接复制了，用到再研究，觉得没什么卵用

    1. # 4. 对齐方式
    2. """
    3. cell = sheet.cell(1, 1)
    5. # horizontal，水平方向对齐方式："general", "left", "center", "right", "fill", "justify", "centerContinuous", "distributed"
    6. # vertical，垂直方向对齐方式："top", "center", "bottom", "justify", "distributed"
    7. # text_rotation，旋转角度。
    8. # wrap_text，是否自动换行。
    9. cell.alignment = Alignment(horizontal='center', vertical='distributed', text_rotation=45, wrap_text=True)
    10. wb.save("p2.xlsx")
    11. """
    13. # 5. 边框
    14. # side的style有如下：dashDot','dashDotDot', 'dashed','dotted','double','hair', 'medium', 'mediumDashDot', 'mediumDashDotDot','mediumDashed', 'slantDashDot', 'thick', 'thin'
    15. """
    16. cell = sheet.cell(9, 2)
    17. cell.border = Border(
    18.     top=Side(style="thin", color="FFB6C1"), 
    19.     bottom=Side(style="dashed", color="FFB6C1"),
    20.     left=Side(style="dashed", color="FFB6C1"),
    21.     right=Side(style="dashed", color="9932CC"),
    22.     diagonal=Side(style="thin", color="483D8B"),  # 对角线
    23.     diagonalUp=True,  # 左下 ~ 右上
    24.     diagonalDown=True  # 左上 ~ 右下
    25. )
    26. wb.save("p2.xlsx")
    27. """
    29. # 6.字体
    30. """
    31. cell = sheet.cell(5, 1)
    32. cell.font = Font(name="微软雅黑", size=45, color="ff0000", underline="single")
    33. wb.save("p2.xlsx")
    34. """
    36. # 7.背景色
    37. """
    38. cell = sheet.cell(5, 3)
    39. cell.fill = PatternFill("solid", fgColor="99ccff")
    40. wb.save("p2.xlsx")
    41. """
    43. # 8.渐变背景色
    44. """
    45. cell = sheet.cell(5, 5)
    46. cell.fill = GradientFill("linear", stop=("FFFFFF", "99ccff", "000000"))
    47. wb.save("p2.xlsx")
    48. """
    50. # 9.宽高（索引从1开始）
    51. """
    52. sheet.row_dimensions[1].height = 50
    53. sheet.column_dimensions["E"].width = 100
    54. wb.save("p2.xlsx")
    55. """