我寫了一段python代碼，用來打開excel檔案，然后整理后另存。但附件的這個excel檔案無法打開，請幫我看看怎么回事呢？謝謝了！
（提問怎么上傳附件啊？
）
import pandas as pd
import glob
import os
input_path = 'D:/pythonProject/venv'
output_file = 'D:/pythonProject/venv/result/test111.xlsx'
def W_Excel(input_path,output_file):
dataframe = []
all_workbooks = glob.glob(os.path.join(input_path,'*.xls*'))
print(all_workbooks)
for workbook in all_workbooks:
all_worksheets = pd.read_excel(workbook,sheet_name=None,index_col=None)
for worksheet_name, data in all_worksheets.items():
dataframe.append(data.loc[(data['建立日期']=='2019/6/12') & (data['公里數']==2566)])
all_data_concatenated = pd.concat(dataframe,axis=0,ignore_index=True)
write = pd.ExcelWriter(output_file)
all_data_concatenated.to_excel(write,sheet_name='new',index=False)
write.save()
if __name__ == "__main__":
W_Excel(input_path, output_file)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/159650.html
上一篇：云上資料安全