excel读取

#coding: utf-8
import xlrd
class Xlinfo(object):
    def __init__(self,path = ''):
        # 打开工作簿
        self.xl = xlrd.open_workbook(path)
    #excel将数字默认作为float处理
    def floatToStr(self, val):
        #若为float则转化为string再返回，若为其他则直接返回
        if isinstance(val, float):
            val =str(int(val))
        return val
#   将Excel中某sheet工作表中数据读取到由字典组成的list中
    def get_sheet_info(self):
        listkey = ['uname','pwd']
        infolist = []
        # 忽略第0行标题行
        for row in range(1, self.sheet.nrows):
            info =[self.floatToStr(val) for val in self.sheet.row_values(row)]
            tmp = zip(listkey, info)
            infolist.append(dict(tmp))
        return infolist

#     通过名字获取工作表
    def get_sheetinfo_by_name(self, name):
        self.sheet = self.xl.sheet_by_name(name)
        return self.get_sheet_info()

    # 通过索引获取工作表
    def get_sheetinfo_by_index(self, index):
        self.sheet = self.xl.sheet_by_index(index)
        return self.get_sheet_info()


if __name__ == '__main__':
    path = r'D:\guojunqi\user_info.xlsx'
    info = Xlinfo(path).get_sheetinfo_by_index(0)
    print info