| 12345678910111213141516171819202122232425262728293031323334353637 |
- #!/usr/bin/env python
- # -*- coding: windows-1251 -*-
- # Copyright (C) 2005 Kiseliov Roman
- from xlwt import *
- from datetime import datetime
- w = Workbook()
- ws = w.add_sheet('Hey, Dude')
- fmts = [
- 'M/D/YY',
- 'D-MMM-YY',
- 'D-MMM',
- 'MMM-YY',
- 'h:mm AM/PM',
- 'h:mm:ss AM/PM',
- 'h:mm',
- 'h:mm:ss',
- 'M/D/YY h:mm',
- 'mm:ss',
- '[h]:mm:ss',
- 'mm:ss.0',
- ]
- i = 0
- for fmt in fmts:
- ws.write(i, 0, fmt)
- style = XFStyle()
- style.num_format_str = fmt
- ws.write(i, 4, datetime.now(), style)
- i += 1
- w.save('dates.xls')
|