pandas操作excel

引入包

import numpy
import pandas
import pymysql

创建写入对象

writer = pandas.ExcelWriter(os.path.join(tar_path, file_name + '.xlsx'))

转化为dataframe对象

 f = pandas.DataFrame(numpy.array(列表), columns=['指定列'])

写入excel

f.to_excel(writer, index=False, sheet_name='指定sheet页')

关闭对象

writer.save()
writer.close()