python读取存储xlsx文件

python操作xlsx文件（打开xlsx文件为<class 'openpyxl.worksheet.worksheet.Worksheet'>对象）不如R方便 （直接打开生成dataframe，便于统计分析）。

from openpyxl import load_workbook

wb = load_workbook(filename = "test.xlsx")

print(wb.sheetnames)

print(type(wb['sheet1']))
sheet1 = wb['sheet1']
len_row = sheet1.max_row
len_column = sheet1.max_column
cell_value = sheet1.cell(5, 5).value

## 循环遍历
for n_row in range(3,len_row+1):   # 从第三行开始
    for n_col in range(1,len_column+1):
        print (sheet1.cell(n_row, n_col).value)

print(len_row)
print(len_column)
print(cell_value)

# 修改内容
sheet1.cell(5, 5).value = 1

sheet2 = wb['sheet2']
len_row = sheet2.max_row
len_column = sheet2.max_column
cell_value = sheet2.cell(3, 3).value

print(len_row)
print(len_column)
print(cell_value)

sheet3 = wb['sheet3']
len_row = sheet3.max_row
len_column = sheet3.max_column
cell_value = sheet3.cell(7, 7).value

print(len_row)
print(len_column)
print(cell_value)

## 保存
wb.save(filename="test22.xlsx")
wb.close()