python 读写处理excel保存文件

import  pandas  as pd
import pymysql,emoji,sys,requests
import re,sys,time,pymysql
import configparser
import xlrd                           #导入模块
from xlutils.copy import copy  
#导入模块
#wb = xlwt.Workbook(encoding = 'ascii')  #创建新的Excel（新的workbook），建议还是用ascii编码


file1="keaa.xlsx"
file2="kea.xls"
#file2="book1.xls"
rb = xlrd.open_workbook(file2)
wb=copy(rb)
ws=wb.get_sheet("Sheet2")

class DoExcela:
    def do_alldata(self,filename,sheetname,head=0):#返回列表，列表元素是某行内容
        df=pd.read_excel(filename,sheetname,header=head,engine='openpyxl',date_parser=lambda x: pd.to_datetime(x, format='%Y年%m月%d日'))
        lb=[]
        lba=[]
        for i in df.values:
            lb.append(i)
        #lba=lb.reverse()
        return lb
af=DoExcela()
ab=0
sqlstr=[]
ap=[]
cf = configparser.ConfigParser()
ac=cf.read("mydz.ini")

#ws = wb.add_sheet(file2)

abb=0
for aa in af.do_alldata(file1,sheetname='Sheet2',head=0):
    time.sleep(0)
    result=[]
    abb=abb+1
    ida=str(aa[0])
    sql=f'select * from dza where id='+str(ida)
    abc=''
    au=0
    for ii in aa:
        au=au+1
        if au<=2:
            continue
        try:
            ab=str(int(ii))
        except:
            ab="0"
        if ab=="":
            ab="0"
        if abc=="":
            abc=ab
        else:
            abc=abc+","+ab
    print(abc)
    ws.write(abb,1,abc) 

wb.save("mm.xls")
sys.exit(0)