Currently I'm using the engine "openpyxl" in Python to replacing data in excel. It cost me almost 54 min to go through 250k lines. Are there other engine options?
I tried to use xlsxwriter but I my code I need to use mode'a' as well, what is not allowed in xlswriter.
with pd.ExcelWriter(new_file, mode='a',engine='openpyxl', if_sheet_exists='replace') as writer:
df.to_excel(writer, sheet_name='Data', startrow=0, startcol=0)