python读写xlsx

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)