1.8.1行列信息获取
按行获取工作表使用区域数据:worksheet.rows
按列获取工作表使用区域数据:worksheet.columns
获取工作表中最小的行号:worksheet.min_row
获取工作表中最小的列号:worksheet.min_column
获取工作表中最大的行号:worksheet.max_row
获取工作表中最大的列号:worksheet.max_column
获取单元格的行号:cell.row
获取单元格的列号:cell.column
iter方法获取指定区域:
1.按行获取指定工作表单元格区域:worksheet.iter_rows(……)
2.按列获取指定工作表单元格区域:worksheet.iter_cols(……)
import openpyxl
wb =openpyxl.load_workbook('test.xlsx')
ws=wb.worksheets[0]
for row in ws.columns:#ws.rows
print([c.value for c in row])
print(ws.min_column,ws.min_row,ws.max_column,ws.max_row)
print(ws['A1:F3'])#ws['A1':'F3']
print(ws.cell(4,6).value)
for row in ws.iter_rows(min_row=2,max_row=8,max_col=4,min_col=2):
print([c.value for c in row])
#实例应用
ws=wb.active
for r in list(ws.rows)[1:]: # [row for row in ws.rows][1:]:
I=[v.value for v in r]
print(I[0],I[1:])
#按行求取最大值
# total=[sum([c.value for c in row]) for row in ws.iter_rows(min_col=2,min_row=2)]
# name=[c.value for in ws['a'][1:]]
# print(list(zip(name,total)))