#!/use/bin/python3
# coding:utf-8import xlrddef read_excel():# 打开文件workbook = xlrd.open_workbook('Orphanet罕见病名录.fromCHPO.xlsx')# workbook = xlrd.open_workbook('Orph.xls')# 获取所有sheetprint(workbook.sheet_names()) # [u'sheet1', u'sheet2']# 根据sheet索引或者名称获取sheet内容sheet1 = workbook.sheet_by_index(0) # sheet索引从0开始# sheet的名称，行数，列数print(sheet1.name, sheet1.nrows, sheet1.ncols)# 获取整行和整列的值（数组）# rows = sheet1.row_values(3) # 获取第四行内容cols = sheet1.col_values(0) # 获取第三列内容print(cols)cols1 = sheet1.col_values(1) # 获取第三列内容print(cols1)cols2 = sheet1.col_values(2) # 获取第三列内容# print(rows)print(cols2)# # 获取单元格内容print(sheet1.cell(1, 0).value)print(sheet1.cell_value(1, 0))print(sheet1.row(1)[0].value)# 获取单元格内容的数据类型print(sheet1.cell(1, 0).ctype)if __name__ == '__main__':read_excel()