python xlrd 中的 cellname 如何使用？

Question

            book = xlrd.open_workbook(path) #打开excel模板文件
            # 遍历excel文件中的sheet
            print  "%s:"%(file)
            for shn in range(book.nsheets):
                sh = book.sheet_by_index(shn)
                for row in range(sh.nrows):
                    for col in range(sh.ncols):
                        val = str(sh.cell_value(row,col))
                        if val[8:15] == '8000005':
                            print '找到：'
                            print '文件名:',file
                            print 'Sheet名:',sh.name
                            print 'Cell:',sh.cellname(row,col)
                            print 'Cell的行列:%d,%d'%(row,col)

报错，sh 无 cellname

Answer 1

测试成功了。

from xlrd import celname

即可。