To Excel
df.toexcel("df.xlsx", na_rep="None") # or "nan"
From Excel
pd.read_excel("df.xlsx"), na_values="None") # or "nan"