[Tutor] unpacking PyTime

[Bob Gailer]

Etrade Griffiths wrote:
> Hi
>
> I am using the Win32com library to pick up data from an EXCEL spreadsheet 
> but am having trouble with dates.  I want to convert a date read from the 
> XL sheet into a float using this snippet
>
> from win32com.client import dispatch
> import time
>
> xlFile="test.xls"
> xlApp=Dispatch("Excel.Application")
> xlApp.Workbooks.Open(xlFile)
> xlSht=xlApp.Worksheets("data")
>
> # OK so far but the problem comes now ...
>
> curr_date=xlSht.Cells(1,3).Value         # returns PyTime
>
> Not how to get the date (as either yy,mm,dd or a single number aka 
> XL).  The ASPN ActivePython site suggests using
>   
It appears that the ActivePython docs may be wrong, as the only method I 
see for a PyTime object is Format. Looking up Format leads to 
curr_date.Format("%y,%m,%d") to get yy,mm,dd.

Or you can, as the ActivePython docs suggest, use int(curr_date) to get 
an integer value which you can then float.

-- 
Bob Gailer
510-978-4454