from openpyxl import Workbook
from openpyxl import load_workbook
wb = load_workbook('1.xlsx')#猜测格式类型
wb.guess_types =True
ws1 = wb.active
print('总行数', ws1.max_row)print('总列数', ws1.max_column)print('---获取单个单元格的值---')print(ws1['A1'].value)print(ws1[1][0].value)#这里也是A1值,行索引从1、列索引从0算起print('---获取单列的所有值---')for cell in ws1['A']:print(cell.value)print('---获取多列的值(通过切片)---')#如果范围比实际大,如实际只有AB两列,指定A:B,则获取结果返回None,并且C列会被后面.columns和.rows获取到for column in ws1['A:B']:for cell in column:print(cell.value)print('---获取所有列的值---')for column in ws1.columns:#也可用ws1.iter_cols()for cell in column:print(cell.value)print('---获取某行的值---')for cell in ws1[1]:print(cell.value)print('---获取多行的值(通过切片)---')for row in ws1[1:2]:for cell in row:print(cell.value)print('---获取所有行的值---')for row in ws1.rows:#也可用ws1.iter_rows()for cell in row:print(cell.value)
ws1['A1']='sdadasda'
wb.save('1.xlsx')
wb.close()