Python 与 Excel 深度整合：全面教程与实战技巧

1. 深入 openpyxl 操作 Excel

1.1 复杂数据写入

• 写入合并单元格：

  from openpyxl import Workbook
  from openpyxl.utils import get_column_letter
  from openpyxl.styles import Alignment, Font
  
  wb = Workbook()
  sheet = wb.active
  
  # 写入标题并合并单元格
  sheet.merge_cells('A1:D1')
  sheet['A1'] = "Sales Report"
  sheet['A1'].font = Font(bold=True, size=14)
  sheet['A1'].alignment = Alignment(horizontal="center")
  
  # 写入数据
  data = [
      ["Month", "Product A", "Product B", "Total"],
      ["Jan", 100, 150, "=SUM(B2:C2)"],
      ["Feb", 120, 130, "=SUM(B3:C3)"],
  ]
  for row in data:
      sheet.append(row)
  
  # 自动调整列宽
  for col in range(1, sheet.max_column + 1):
      sheet.column_dimensions[get_column_letter(col)].width = 15
  
  wb.save("advanced_data_write.x