气轻Python114 openpyxl合并单元

 

保存数据时，对合并单元的处理。

 

import numpy as np

from openpyxl import Workbook

import datetime

import webbrowser

from openpyxl.styles import *

from openpyxl import load_workbook

 

########################################################@####################

#   qipy114 : 合并单元                                                      #

########################################################@####################

def qipy114():

    fileName = "Data.xlsx"

    wb = load_workbook(fileName)                        # 读取数据

    ws = wb['Sheet1']

    rowsMax = ws.max_row

    colMax = ws.max_column

 

    fname = 'Data1.xlsx'

    wb = Workbook()

 

    ws = wb.active

 

    ws.merge_cells('A1:A2')

    ws.cell(1,1, '日期')

    ws.cell(1,1).font = Font(size=16)

 

    timeLabel = ['早', '中', '晚']

    tmp = ['B1:C1','D1:E1','F1:G1']

    header = dict(zip(timeLabel,tmp))

    for i, s in enumerate(header.keys()):

        ws.merge_cells(header[s])

        ws.cell(1,(i + 1)*2, s)

        ws.cell(1, (i + 1)*2).font = Font(size=16)

 

    timeLabel = ['饭前', '饭后']*3 + [ '体重']

    for i, s in enumerate(timeLabel):

        ws.cell(2,(i + 2), s)

        ws.cell(2, i + 2).font = Font(size=16)

 

    wb.save(fname)

    webbrowser.open(fname)

 

    return

 

if __name__ == "__main__":

    qipy114()

 

执行结果