参考:https://blog.csdn.net/stone9159/article/details/79038629
解决方案:
@classmethod
# 读取csv文件返回一个list-list格式
def read_csv_file(cls, file_path):
try:
rows = []
# with进入执行上下文,退出的时候会自动关闭文件
# 这里读取文件必须加上encoding="utf-8",否则可能报错!
with open(file_path, 'r', encoding="utf-8") as csv_file:
# 读取csv文件中每行的列表,将每行读取的值作为列表返回
csv_read = csv.reader(csv_file)
for row in csv_read:
rows.append(row)
return rows
except Exception as e:
raise Fail(f"csv文件读取失败,错误原因是:{e}")