import pandas as pd
import xlsxwriter
# 把多个CSV写到一个Excel中
rp = r'D:\工作表\test.xlsx'
writer = pd.ExcelWriter(rp,engine = 'xlsxwriter')
rp1 = r'D:\工作表\test1.csv'
df = pd.read_csv(rp1,encoding = 'ANSI',engine = 'python')
df.to_excel(writer,sheet_name = 'test1',index = False)
rp2 = r'D:\工作表\test2.csv'
df1 = pd.read_csv(rp2,encoding = 'ANSI',engine = 'python')
df1.to_excel(writer,sheet_name = 'test2',index = False)
writer.save()
writer.close()
print('finished')
09-08
2676
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-17
5323
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
05-19
1799
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)