datetime data ignore timezone
Hello:
I found even i convert a datetime date with timezone but openpyxl ignore timezone info and write a datetime without timezone.
Here is a little example.
Thank you
from openpyxl import Workbook
from openpyxl.cell import WriteOnlyCell
from datetime import datetime
from pytz import UTC, timezone
wb = Workbook(write_only=True)
ws = wb.create_sheet()
title_cells = [WriteOnlyCell(ws, value="datetime_test"), WriteOnlyCell(ws, value="datetime_convert_tz")]
ws.append(title_cells)
datetime_test = datetime(2020, 7, 13, 2, 1, 2)
datetime_convert_tz = datetime_test.replace(tzinfo=UTC).astimezone(timezone("Asia/Shanghai"))
cells = [WriteOnlyCell(ws, value=datetime_test), WriteOnlyCell(ws, value=datetime_convert_tz)]
ws.append(cells)
# save the file
wb.save('datetime_tz_issue.xlsx')