Revision history [back]

To resolve this issue, you can remove the time zone information from the datetime objects before writing the data frame to Excel. One way to do this is to convert the datetime objects to a string format without time zone information using the strftime() method.

Here's an example code snippet that demonstrates how to do this:

import pandas as pd

# create a sample data frame with datetime objects
df = pd.DataFrame({
    'datetime': ['2021-01-01 12:00:00+00:00', '2021-01-02 12:00:00+00:00'],
    'value': [1, 2]
})
df['datetime'] = pd.to_datetime(df['datetime'])

# remove time zone information from datetime objects
df['datetime'] = df['datetime'].dt.strftime('%Y-%m-%d %H:%M:%S')

# write the data frame to Excel without time zone information
writer = pd.ExcelWriter('output.xlsx')
df.to_excel(writer, index=False)
writer.save()

In this example, we first convert the datetime column to datetime objects using the pd.to_datetime() function. Then we remove the time zone information from the datetime objects by converting them to a string format without time zone information using the strftime() method with the format %Y-%m-%d %H:%M:%S. Finally, we write the data frame to an Excel file using the to_excel() method of the ExcelWriter object.