pip install pyexcel
读取文件以后，在重新写入文件就可以了。
import pyexcel as pe
import pyexcel.ext.xls # import it to handle xls file
import pyexcel.ext.xlsx # import it to handle xlsx file
records = pe.get_records(file_name="your_file.xls")
for record in records:
print("%s is aged at %d" % (record['Name'], record['Age']))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024