【Python读取excel】

from openpyxl import load_workbook
import os

# 打开excel
# workbook对象，里面包含了很多的数据
file_path = os.path.join("db", "salary.xlsx")
if os.path.exists(file_path):
    wb = load_workbook(file_path)  # 打开excel
else:
    print("文件不存在")

print(wb.sheetnames)
sheet = wb.worksheets[0]

# 获取每一行,min_row从哪一行开始
for row in sheet.iter_rows(min_row=2):
    cell0 = row[0]
    cell3 = row[3]
    print(cell0.value, cell3.value)

# 读取excel表格
file_path = os.path.join("db", "salary.xlsx")
wb = load_workbook(file_path)
sheet = wb.worksheets[0]

# 获取表头
header = []
head_row = sheet[1]
for cell in head_row[4:]:
    header.append(cell.value)
# print(header)
# 寻找某些行
for row in sheet.iter_rows(min_row=2):
    email = row[3].value
    part_row_list = row[4:]
    row_data_list = []
    index = 0
    for cell in part_row_list:
        header_name = header[index]
        row_data_list.append([header_name, cell.value])
        # index = index + 1
        index += 1
    # print(email, row_data_list)

    # 构建邮件的内容
    # ["基本工资：900"]
    group_list = []
    for ele_list in row_data_list:
        group = "{}:{}".format(ele_list[0], ele_list[1])
        group_list.append(group)
        email_string = ";".join(group_list)
    print(email_string)

以上是excel中的数据

以上是python中的运行结果