如何解决此错误：openpyxl.utils.exceptions.IllegalCharacterError

Question

我在Python中运行了这段简单的代码，以合并两个excel工作表，并在多个键上进行外部连接。我一直得到上面的错误

请参阅下面的代码：

enter code here 
import pandas as pd
import os
import glob

excel1 = 'Cbr_Data.xlsx'
excel2 = 'output.xlsx'

df1 = pd.read_excel(excel1)
df2 = pd.read_excel(excel2)

new_Npower = pd.merge(df1,df2, how='outer', on=['firstname', 'surname', 'residence_state', 
'residence_lga', 'program'], indicator=True)
writer = pd.ExcelWriter('final_copy.xlsx')
# write dataframe to excel
new_Npower.to_excel(writer)
# save the excel

writer.save()
print('DataFrame is written successfully to Excel File.')

Answer 1

你可以这样试试

import pandas as pd
import os
import glob

excel1 = 'Cbr_Data.xlsx'
excel2 = 'output.xlsx'

df1 = pd.read_excel(excel1)
df2 = pd.read_excel(excel2)

new_Npower = pd.merge(df1,df2, how='outer', on=['firstname', 'surname', 'residence_state', 
'residence_lga', 'program'], indicator=True)

new_Npower.to_excel('file_name.xlsx')
print('DataFrame is save to excel file successfully')