Mark Hammond wrote:
> Your solution seems to be to simply construct a datetime
> object from the
> pywintypes time object by way of attributes - eg:
>
> >>> from win32com.client import Dispatch
> >>> import datetime
> >>> xl=Dispatch("Excel.Application")
> >>> d=xl.Range("A1").Value
> >>> datetim
> the docs didn't explicitly cite the existance of those attributes...
Well in fact they do (at least my version of the
.chm does) and to my shame I hadn't looked there,
relying on a quick dir (), which only shows the
.Format method.
> Now the code is much more readable :-)
Indeed.
TJG
___
On 5/8/07, Mark Hammond <[EMAIL PROTECTED]> wrote:
Your solution seems to be to simply construct a datetime object from the
pywintypes time object by way of attributes - eg:
>>> from win32com.client import Dispatch
>>> import datetime
>>> xl=Dispatch("Excel.Application")
>>> d=xl.Range("A1").Va
> I have an Excel file with many dates beyond 2038, which arrive to me as a
list of PyTime objects.
> From the doc I have found (
http://aspn.activestate.com/ASPN/docs/ActivePython/2.4/pywin32/PyTime.html )
> it appears that an int conversion is needed to handle them.
To answer Mark's question fir
thanks :)
I resorted to your solution:
for i in DataList:
OutputList.append(datetime.date(int(i.Format("%Y")),
int(i.Format("%m")),
int(i.Format("%d"
return OutputList
and it works. I am considering dates up to 50 years from now so 2038 is
definitely too early :-)
Francesco
On 5/
Mark Mc Mahon wrote:
> Hi,
>
> Maybe there is a better way then this suggestion...
>
> from datetime import datetime
>
> date =
>
> day = int(xl.activecell.value.Format("%d"))
> month = int(xl.activecell.value.Format("%m"))
> year = int(xl.activecell.value.Format("%Y"))
>
> date_as_datetime =
Hi,
Maybe there is a better way then this suggestion...
from datetime import datetime
date =
day = int(xl.activecell.value.Format("%d"))
month = int(xl.activecell.value.Format("%m"))
year = int(xl.activecell.value.Format("%Y"))
date_as_datetime = datetime(year, month, day)
PyTime is starting
hello,
I have another newbie question. I have googled around but didn't find an
answer.
I have an Excel file with many dates beyond 2038, which arrive to me as a
list of PyTime objects. From the doc I have found (
http://aspn.activestate.com/ASPN/docs/ActivePython/2.4/pywin32/PyTime.html )
it app
