Problem assigning timevalue to Excel - COM

[Eduard Hiti]

> I haven't found out what type and/or format to use when assigning a value
to
> a cell in MS Excel having a predefined time format like this:
> 1997-04-03  12:15:00
>
> When reading - via COM - from a cell with a manually entered content, I
get
> a 'time object' back.
> This 'time object' is recognized as being of 'TimeType' and can be
converted
> to an int.
>
> How can I convert an int into something that can be assigned to the Value
> property of the desired cell and be accepted according to the format as of
> above?
>

I recall the module mxDateTime being mentioned to have support for COM date
values. I don't have a URL ready, but it is a fairly popular module, so you
should have no trouble finding it on python.org or parnassus.

Bye,

    Eduard Hiti