立即学习:https://edu.csdn.net/course/play/24756/280721?utm_source=blogtoedu
import xlrd
content=xlrd.open_workbook("G:/论文资料/医疗风险/BWM.xls","rb")
sheet=content.sheet_by_index(0)
注意:所有行和列的编号从0开始
1.sheet.cell(row,col),获取指定行和列的cell对象:
cell=sheet.cell(1,1)
print(cell,value)
2.sheet.row_slice(row,start_col,end_col):获取指定行的某几列的cell对象:
cells=sheet.row_slice(1,1,4)
for cell in cells:
print(cell.value)
3.sheet.col_slice(col,start_row,end_row):获取指定列的某几行的cell对象:
cells=sheet.col_slice(0,1,sheet.nrows)(全部行)
for cell in cells:
print(cell.value)
4.sheet.cell_value(row,col):获取指定行和列的值:
cell_value=sheet.cell_value(0,1)
print(cell_value)
5.sheet.row_values(row,start_col,end_col):获取指定行的某几列的值:
cell_values=sheet.row_values(1,1,5)
print(cell_value)
6.sheet.col_values(col,start_row,end_row):获取指定列的某几行的值:
cell_values=sheet.col_values(1,1,5)
print(cell_value)