学习笔记（34):150讲轻松搞定Python网络爬虫-Excel处理-打开Excel和获取Sheet

立即学习:https://edu.youkuaiyun.com/course/play/24756/280720?utm_source=blogtoedu

import xlrd

1.sheet_names：获取所有的sheet的名字:

content=xlrd.open_workbook("G:/论文资料/医疗风险/BWM.xls","rb")

print(content.sheet_names())

2.sheet_by_index：根据索引获取sheet对象:

workbook=xlrd.open_workbook("G:/论文资料/医疗风险/BWM.xls","rb")

sheet=workbook.sheet_by_index(0)

print(sheet.name)

3.sheet_by_name：根据名字获取sheet对象:

sheet=workbook.sheet_by_name("weight")

print(sheet.name)

4.sheets：获取所有的sheet对象:

sheets=workbook.sheets()

for sheet in sheets:

    print(sheet.name)

5.sheet.nrows：这个sheet中的行数:sheet.ncols：这个sheet中的列数
 

sheet=workbook.sheet_by_index(0)

print({"rows":sheet.nrows,"cols":sheet.ncols})