from openpyxl import Workbook

from openpyxl import load_workbook

# 加载workbook，注意，openpyxl只支持xlsx格式

wb = load_workbook(filename=r"C:\\Users\\Administrator\\Desktop\\test.xlsx")

'''读取数据'''

num = wb.get_named_ranges

print(num)

# 获取每个sheet的名称

sheetnames = wb.get_sheet_names()

print(sheetnames)

# 获得第一个sheet

ws = wb.get_sheet_by_name(sheetnames[0])

print(ws)

ws = wb.active

# 写数据 第一种方式

ws['A4'] = 123

# 第二种方式

ws.cell(row=2, column= 3).value = 'bobo'

# 获取一个单元格的数据

c = ws['A4'].value

c2 = ws.cell(row= 2,column= 2).value

print(c,c2)

c3 = ws.cell(row=2, column=3).value

print(c3)

# 一次获取多个单元格的数据

cell_range = ws['A1':'B2']

cell_range2 = tuple(ws.iter_rows('A1:B2')) python3 有警告

for cell in cell_range:

print(cell)

for each_cell in cell:

print(each_cell.value)

# 保存写进去的数据

wb.save("C:\\Users\\Administrator\\Desktop\\test.xlsx")