1. 读取excel的基本步骤
import xlrd
# 打开excel
data = xlrd.open_workbook(r'D:\test_0804\yingkun.xlsx',)
# 读取所有sheet的name
names = data.sheet_names()
# 打开某个sheet
table = data.sheet_by_index(0)
table = data.sheet_by_name(names[0])
# 获取行数和列数
rowNum = table.nrows
colNum = table.ncols
print(rowNum, colNum)
# 按行读取
for i in range(rowNum):
print(table.row_values(i))
2. 按行读取
# 按行读取
for i in range(rowNum):
print(table.row_values(i))
3. 按列读取
# 按列读取
for i in range(colNum):
print(table.col_values(i))
4. 读取单元格
# 读取每个单元格的内容, 3种方式
for i in range(rowNum):
for j in range(colNum):
cell = table.cell(i, j).value