【开发者笔记】python

题记：

　　最近做Python导入接口，用到xlrd包读取excel文件信息入库，获取合并单元格信息时遇到时而成功时而失败的情况，一开始用xls文件读取不了合并单元格信息，后来换用xlsx格式可以读取。但将导出的文件再重新导入时获取合并单元格信息又失败了。没办法去看看源码看能不能突破，说实话看源码真的头疼，去源码里面搜merge发现里面的 sheet.merged_cells 属性并没有什么特别的地方。后来读merged_cells 头部的注释是发现一个叫formatting_info的参数，然后问题迎刃而解。遂记之。

源码注释：

 ##
    # 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

 

 

能通过百度解决的问题，就不打扰别人；

能通过问人解决的问题，就不读源码；

能通过源码解决的问题，就不自己Coding；