python新人关于编码跪求各位大神,请大神们帮帮忙

遇到一个问题。我用openpyxl创建了一个csv文件,但是在读取csv文件的时候报错,报错为UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xad in position 11: invalid start byte。新人实在是不知道怎么弄了。。求大神们帮帮忙,代码如下
`import os
from openpyxl import load_workbook,Workbook
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
import csv

path = ‘C:/Users/TF/Desktop/工资条测试/工资条测试.xlsx’
path_1 = ‘C:/Users/TF/Desktop/工资条测试/test/’
path_3 = ‘C:/Users/TF/Desktop/工资条测试/demo/’
wb = load_workbook(path)
ws = wb.active
payroll = Workbook()
salary = payroll.active
header = []
content = []
for x in ws[1] :#获取表头数据
header.append(x.value)
n = 0
z =0
for a in ws.iter_rows(min_row =1,max_row = ws.max_row,min_col=1,max_col=ws.max_column,values_only=True) :#获取内容
n+=1
if n%2 == 0 :
content.append(a)
salary.append(header) #添加表头
for b in range(len(content)) : #转换为CSV
c = content[b]
name = content[b][1]
file = name+’.xlsx’
path_2 = path_1+file
salary.append©
payroll.save(path_2)

with open(path_2,‘r’,encoding=‘utf-8’,newline = ‘’) as source_file :
source_csv = csv.DictReader(source_file)
headers = source_csv.fieldnames
for row in source_csv :
file_name = row[‘姓名’]+‘csv’
csv_path = path_3+file_name
with open(csv_path, ‘w’, encoding=‘utf-8’, newline=’’) as target_file:
target_writer = csv.DictWriter(target_file, fieldnames=headers)
target_writer.writeheader()
target_writer.writerow(row)
`

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值