# 获取第一列数据
type_list = []
i = 2
while True:
    r = ws.cell(i, 1).value
    if r:
        type_list.append(r)
    else:
        break
    i += 1
file = r'aa.xlsx'
# 判断合并单元格的始末位置
start = 0
end = 0
flag = type_list[0]
for i in range(len(type_list)):
    if type_list[i] != flag:
        flag = type_list[i]
        end = i - 1
        if end >= start:
            ws.merge_cells("A" + str(start + 2) + ":A" + str(end + 2))
            start = end + 1
    if i == len(type_list) - 1:
        end = i
        ws.merge_cells("A" + str(start + 2) + ":A" + str(end + 2))
wb.save(file)
                                    插入行和列¶可以使用工作表的一些方法插入或删除行或列：openpyxl.worksheet.worksheet.Worksheet.insert_rows() openpyxl.worksheet.worksheet.Worksheet.insert_cols() openpyxl.worksheet.worksheet.Worksheet.delete_rows() openpyxl.works...
                                    I'm trying to delete cells from an Excel spreadsheet using openpyxl.  It seems like a pretty basic command, but I've looked around and can't find out how to do it.  I can set their values to None, but...
                                    Microsoft Office 被广泛用于商务和运营分析中， 其中 Excel 尤其受欢迎。Excel 可以用于存储表格数据、创建报告、图形趋势等。在深入研究用 Python 处理 E...
                                    多个excel, 每个excel有多个sheets. 要统计每个sheet的最大行数，并写入到一个新的excel 文件中。
#import package
import pandas as pd
from openpyxl import load_workbook
from openpyxl import Workbook
import os
#将excel 表名，页签名，每页最大行数记录到列表中lis，再将lis这个列表放入final_data列表中
def getrownum_allsheet(tab