利用pandas+xlwt 合并单元格

需求：根据某一列的值对指定的其他列做合并操作(根据A列，对BC列作合并单元格)

import xlwt
import pandas as pd
class Merge_cell():
    '''
    目标：根据某列值对指定列值进行合并
    '''

    def __init__(self, excel_path, df, key_col, col2):
        self.excel_path = excel_path
        self.df = (df.drop(columns='index') if 'index' in df.columns else df)
        self.key_col = key_col
        self.col2 = col2
        self.wb = xlwt.Workbook(excel_path)
        self.worksheet = self.wb.add_sheet('sheet1')

    def _get_idx(self):
        groups = self.df.groupby(self.key_col)
        idxs = [[groups.get_group(i).index.min() + 1, groups.get_group(i).index.max() + 1] for i in groups.size().index]
        return idxs, len(idxs)

    def _get_content(self, idx, key