python读取csv,excel文件内容脚本

最近在练习自动化测试，需要读取csv,excel中的测试数据
from csv import DictReader
from openpyxl import load_workbook
def read_csv(file):
with open(file,encoding=‘utf-8-sig’) as f:
reader=DictReader(f)
for d in reader:
yield d
def read_excel(file):
wb=load_workbook(file)
ws=wb.active
for d in ws.iter_rows(values_only=True,min_row=2):
yield d

if name==“main”:
for data in read_excel(r"E:\pythonProjectUI202524\datas\readxlsx.xlsx"):
print(data)
注意：csv文件里需要将编码格式调整为utf-8，添加BOM

这样数据才能实时编写，存储，正确识别格式