pandas.ExcelWriter ValueError: Append mode is not supported with xlsxwriter

Try with this:

with pd.ExcelWriter("existing_file_name.xlsx", engine="openpyxl", mode="a") as writer:
    df.to_excel(writer, sheet_name="name", startrow=num, startcol=num)

You need to specify the engine as “openpyxl”.