引入fix_border.py文件，以下是其完整代码：

#!/usr/bin/env python
#-*-conding=utf-8-*-
from itertools import product
import types
import openpyxl
from openpyxl.utils import get_column_letter
from openpyxl import worksheet
from openpyxl.utils import range_boundaries
from itertools import product
import regex as re                  #此为第三方模块，需pip install regex安装，regex基本兼容re模块

def patch_worksheet():
    """
    这monkeypatches工作表。删除单元格删除错误
    https://bitbucket.org/openpyxl/openpyxl/issues/365/styling-merged-cells-isnt-working
    """
    def merge_cells(self, range_string=None, start_row=None, start_column=None, end_row=None, end_column=None):
        """ 
        在单元格范围中设置merge。Range是单元格范围(例如A1:E1)
        这是monkeypatched删除单元格删除错误
        """
        if not range_string and not all((start_row, start_column, end_row, end_column)):
            msg = "You have to provide a value either for 'coordinate' or for\ 'start_row', 'start_column', 'end_row' *and* 'end_column'"
            raise ValueError(msg)
        elif not range_string:
            range_string = '%s%s:%s%s' % (get_column_letter(start_column),
                                          start_row,
                                          get_column_letter(end_column),
                                          end_row)
        elif ":" not in range_string:
            if COORD_RE.match(range_string):
                return  # 单个单元格，什么都不做
            raise ValueError("Range must be a cell range (e.g. A1:E1)")
        else:
            range_string = range_string.replace('$', '')
        if range_string not in self.merged_cells:
            self.merged_cells.add(range_string)
        #以下是由这个monkeypatch删除的:
        # min_col, min_row, max_col, max_row = range_boundaries(range_string)
        # rows = range(min_row, max_row+1)
        # cols = range(min_col, max_col+1)
        # cells = product(rows, cols)
        # all but the top-left cell are removed
        #for c in islice(cells, 1, None):
            #if c in self._cells:
                #del self._cells[c]
    #使用monkey patch
    worksheet.Worksheet.merge_cells = merge_cells
patch_worksheet()

在自己的程序中导入上面文件：

from fix_border import patch_worksheet

然后在load文件前加上patch_worksheet()

全部代码为（未验证）：

ws = opx.load_workbook(filename1)
fix_border.patch_worksheet()
ws.save(filename2)