New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Various issues with timezone aware datetime objects (datetime, numpy, pandas) #195

Closed
acommendador opened this Issue Jun 13, 2015 · 2 comments

Comments

Projects
None yet
2 participants
@acommendador

acommendador commented Jun 13, 2015

Replicate with the following code:

from xlwings import Workbook, Range
import pandas as pd
import numpy as np
dt = np.datetime64(1434149887000,'ms')
data_list = np.empty(1, dtype=np.float64)
data_list[:] = 1
dti = pd.DatetimeIndex(data=[dt],tz='GMT')
df = pd.DataFrame(data=data_list, index=dti, columns=['A'])
wb = Workbook()
Range('A1',wkb=wb).value = df

The code will work if line dti = pd.DatetimeIndex(data=[dt],tz='GMT') is changed to dti = pd.DatetimeIndex(data=[dt]).

We found that it hangs during the last line of the main.py Range value method: xlplatform.set_value(xlplatform.get_range_from_indices(self.xl_sheet, self.row1, self.col1, row2, col2), data).

@fzumstein fzumstein added the bug label Jun 13, 2015

@fzumstein fzumstein added this to the v0.3.6 milestone Jun 13, 2015

@fzumstein fzumstein modified the milestones: v0.3.6, v0.3.7 Jul 12, 2015

@fzumstein fzumstein modified the milestones: v0.3.7, v0.3.8 Sep 10, 2015

@fzumstein

This comment has been minimized.

Member

fzumstein commented Sep 26, 2015

This happens on Mac, correct? - never mind, there were a few things going on...

@fzumstein

This comment has been minimized.

Member

fzumstein commented Sep 26, 2015

Fixed by af128a9

@fzumstein fzumstein closed this Sep 26, 2015

@fzumstein fzumstein changed the title from xlwings hangs when using a pandas dataframe with timezone aware datetimeindex to Various issues with timezone aware datetime objects (datetime, numpy, pandas) Sep 26, 2015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment