测试数据：
读取该表格内容：
代码如下：
def open():
from openpyxl import load_workbook
wb = load_workbook('C:/Users/admin/Desktop/baihuo.xlsx')
###获取工作簿
sh1 = wb.active
sh2 = wb['Sheet1']
sh3 = wb.get_sheet_by_name('Sheet1')
print(sh1 is sh2 is sh3)
def show_sheets():
####获取工作表
from openpyxl import load_workbook
wb = load_workbook('C:/Users/admin/Desktop/baihuo.xlsx')
print(wb.sheetnames)
for sh in wb:
print(sh.title)
def get_one_value():
from openpyxl import load_workbook
wb = load_workbook('C:/Users/admin/Desktop/baihuo.xlsx')
sh1 = wb.active
###取第二行，第3列的值即c列2行的值
value1 = sh1.cell(2,3).value
value2 = sh1['c2'].value
print(value1,value2)
def get_many_value():
from openpyxl import load_workbook
wb = load_workbook('C:/Users/admin/Desktop/baihuo.xlsx')
sh1 = wb['Sheet1']
##切片
cells1 = sh1['c2':'d3']
# print(cells1)
##整行，整列
cell_row3 = sh1[3]
cell_col3 = sh1['c']
print(cell_row3)
print(cell_col3)
cell_row3_5 = sh1[3:5]
print(cell_row3_5)
###通过迭代获取数据
#for row in sh1.iter_rows(min_row = 2,max_row = 5,max_col = 3):
# for cell in row:
# print(cell.value)
#for row in sh1.iter_rows(min_row = 2, max_row = 5, min_col = 2,max_col = 4):
#for cell in row:
#print(cell.value)
def get_all_data():
from openpyxl import load_workbook
wb = load_workbook('C:/Users/admin/Desktop/baihuo.xlsx')
sh1 = wb['Sheet1']
##########逐行显示数据
#for row in sh1.rows:
#for cell in row:
#print(cell.value)
###########逐列显示数据
for column in sh1.columns:
for cell in column:
print(cell.value)
def get_num():
from openpyxl import load_workbook
wb = load_workbook('C:/Users/admin/Desktop/baihuo.xlsx')
sh1 = wb['Sheet1']
print(sh1.max_row)
print(sh1.max_column)
if __name__ == "__main__":
open()
show_sheets()
get_one_value()
get_many_value()
get_all_data()
get_num()
实现效果如下：
