Append Mode for ExcelWriter with "xlsxwriter"

[engkimbs]

Problem description

ExcelWriter's append mode doesn't work when setting default xlsxwriter. To use append mode, I have to set the engine openpyxl. I think it is inconvenient and slow. So I suggest ExcelWriter can be set as append mode when default (xlsxwriter).

Sample Code

AS-IS

writer = pd.ExcelWriter('APT_TRADE.xlsx', engine='openpyxl', mode='a')
apt_dataframe.to_excel(writer, sheet_name='city-' + date.strftime("%Y%m"), index=False)

TO-BE

writer = pd.ExcelWriter('APT_TRADE.xlsx', mode='a')
apt_dataframe.to_excel(writer, sheet_name='city-' + date.strftime("%Y%m"), index=False)

[WillAyd]

See this comment from the xlsxwriter maintainer #3441 (comment)

So not possible unless anything has changed that @jmcnamara is aware of

[jmcnamara]

@WillAyd You are correct. XlsxWriter doesn’t, and won’t, support rewriting or appending to XLSX files.