pip install openpyxl==3.0.10
目前高版本可能有通配符bug
from openpyxl import Workbook
from openpyxl import load_workbook
#写
wb = Workbook()
# s=wb.active
s = wb.create_sheet('1')
#删掉默认的表
wb.remove(wb['Sheet'])
s.append(['图片地址','预测类别','输入数据'])
s.append([1,2,3])
wb.save('1.xlsx')
#读
wb = load_workbook('1.xlsx', data_only=True)
# 激活默认表
# sheet = wb.active
#更改表名
# sheet.title='1'
# 获取所有工作表名
names = wb.sheetnames
for i in names:
sheet = wb[i]
'''
# 获取融合单元格
merged_cells = sheet.merged_cells.ranges
for merged_cell in merged_cells:
min_col, min_row, max_col, max_row = merged_cell.bounds
print(min_col, min_row, max_col, max_row)
'''
# 获取最大行数
maxRow = sheet.max_row
# maxColumn = sheet.max_column
'''
当数据量较大时使用如下代码遍历会快很多
for row in sheet.rows:
#第一列为row[0]
print(row[0].value)
'''
for j in range(1, maxRow + 1):
#第一个单元格为sheet.cell(1,1)
print(sheet.cell(j, 1).value,sheet.cell(j, 2).value,sheet.cell(j, 3).value)