##

    # List of address ranges of cells which have been merged.

    # These are set up in Excel by Format > Cells > Alignment, then ticking

    # the "Merge cells" box.

    # <br> Note that the upper limits are exclusive: i.e. <tt>[2, 3, 7, 9]</tt> only

    # spans two cells.

    # <br> -- New in version 0.6.1. Extracted only if open_workbook(formatting_info=True).

    # <br>How to deconstruct the list:

    # <pre>

    # for crange in thesheet.merged_cells:

    #     rlo, rhi, clo, chi = crange

    #     for rowx in xrange(rlo, rhi):

    #         for colx in xrange(clo, chi):

    #             # cell (rlo, clo) (the top left one) will carry the data

    #             # and formatting info; the remainder will be recorded as

    #             # blank cells, but a renderer will apply the formatting info

    #             # for the top left cell (e.g. border, pattern) to all cells in

    #             # the range.

    # </pre>

    merged_cells = []

   def read_excel_as_merge(self,file_name):
　　　　 # 读取合并单元格信息，按照平铺方式展开，合并单元格按照合并单元格的最左上单元格填充

        data = []

        wb = xlrd.open_workbook(file_name,'r',formatting_info=True)

        sheet = wb.sheet_by_name(wb.sheet_names()[0])

        merge = sheet.merged_cells

        for ri in range(sheet.nrows):

            # print(sheet.row_values(r))

            row = []

            for ci in range(sheet.ncols):

                v = sheet.cell(ri, ci).value

                for rg in merge:

                    a, b, c, d = rg

                    if ri >= a and ri < b and ci >= c and ci < d:

                        v = sheet.cell(a, c).value

                row.append(v)

            data.append(row)

        return data,merge