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
Hi,
Maybe there is a better way then this suggestion...
from datetime import datetime
date = some PyTime object
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)
Mark Mc Mahon wrote:
Hi,
Maybe there is a better way then this suggestion...
from datetime import datetime
date = some PyTime object
day = int(xl.activecell.value.Format(%d))
month = int(xl.activecell.value.Format(%m))
year = int(xl.activecell.value.Format(%Y))
date_as_datetime =
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
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).Value
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
Hi,
after hours of searching, testing and hoping to code for vista never again ;)
i tried to call an application with everything i found...
sometimes py2exe couldn't load the needed modules.
but every time the app stuck. it seems that ShellExecuteEx doesnt word with
py2exe... maybe i'm wrong. i
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
datetime.datetime(d.year, d.month,
Mark,
My apologies -- I tried to relay that I have tried both ways -- early
and late dispatch
Here is the output after running the makepy routine on the type and object
libraries for Photoshop
---
2.5.1
As a follow-up question is there a way to see what python thinks the
variable should be ? In looking at the file created by makepy I see the
function call for select but nothing that looks to me like information
relating to the type of variable that needs to be generated
here is the method
10 matches
Mail list logo