python 读取excel 并将对应生成浮点数据进行处理

1.python 读取excel 检简单 

def open_excel(file=u'D:\\python27File\\crmAutoTest\\configFile\\logincase.xlsx'):
#     try:
#         data = xlrd.open_workbook(file)
#         return data
#     except Exception as e:
#         print(str(e))
# def excel_table_byname(file= u'D:\\python27File\\crmAutoTest\\configFile\\logincase.xlsx',colnameindex=0,by_name=u'Sheet1'):#修改自己路径
#      data = open_excel(file)