python写入和读取
我们可以利用模块pandas
import pandas as pd
pd.read_excel/table/csv(路径)
写入有两种,一种是通过DataFrame,另外一种是ExcelWriter
new_df=pd.DataFrame()
new_df=df
new_df.to_excel(filename,index=False, encoding='utf_8_sig')
writer = pd.ExcelWriter(filename)
df.to_excel(writer)
writer.save()