dates.py 562 B

12345678910111213141516171819202122232425262728293031323334353637
  1. #!/usr/bin/env python
  2. # -*- coding: windows-1251 -*-
  3. # Copyright (C) 2005 Kiseliov Roman
  4. from xlwt import *
  5. from datetime import datetime
  6. w = Workbook()
  7. ws = w.add_sheet('Hey, Dude')
  8. fmts = [
  9. 'M/D/YY',
  10. 'D-MMM-YY',
  11. 'D-MMM',
  12. 'MMM-YY',
  13. 'h:mm AM/PM',
  14. 'h:mm:ss AM/PM',
  15. 'h:mm',
  16. 'h:mm:ss',
  17. 'M/D/YY h:mm',
  18. 'mm:ss',
  19. '[h]:mm:ss',
  20. 'mm:ss.0',
  21. ]
  22. i = 0
  23. for fmt in fmts:
  24. ws.write(i, 0, fmt)
  25. style = XFStyle()
  26. style.num_format_str = fmt
  27. ws.write(i, 4, datetime.now(), style)
  28. i += 1
  29. w.save('dates.xls')