cannot write resampled frame to excel TypeError: 'Period' object does not support indexing
Excel_to function is not working with some dataframes with period index

# this works for a dataframe with timeseries index
close.to_excel("temp.xlsx")

# this does not work. fails with error shown above
monthly=close.resample('M', kind='period')
monthly.to_excel("temp.xlsx")
