Formatting Excel cells with PythonCOM
sbarron at ansic.net
Fri Apr 7 16:25:13 CEST 2000
Wouldn't you know not 5 minutes after I posted the messag I figured it
out using the Excel VBA help. Anyway, thanks for the information. Btw,
I bought and read your PPW over my spring break and it helped me
Mark Hammond wrote:
> This code is from the win32com test suite (in testMSOffice.py)
> # test dates out with Excel
> xl.Cells(5,1).Value = "Excel time"
> xl.Cells(5,2).Formula = "=Now()"
> import time
> xl.Cells(6,1).Value = "Python time"
> xl.Cells(6,2).Value = pythoncom.MakeTime(time.time())
> xl.Cells(6,2).NumberFormat = "d/mm/yy h:mm"
More information about the Python-list