diff options
| author | Kenneth Reitz <me@kennethreitz.com> | 2010-10-06 13:42:52 -0400 |
|---|---|---|
| committer | Kenneth Reitz <me@kennethreitz.com> | 2010-10-06 13:42:52 -0400 |
| commit | 96c93871cf1e8f047b6656912636cc638f2a1808 (patch) | |
| tree | 877c6e814b2ef0e5670b52121c5f79d709021e77 /tablib/packages/xlwt/examples/dates.py | |
| parent | a54949bc08e7323bb7b276d8b8acd7ab0ec5a397 (diff) | |
| download | tablib-96c93871cf1e8f047b6656912636cc638f2a1808.tar.gz | |
Vendorized XLWT.
Diffstat (limited to 'tablib/packages/xlwt/examples/dates.py')
| -rw-r--r-- | tablib/packages/xlwt/examples/dates.py | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/tablib/packages/xlwt/examples/dates.py b/tablib/packages/xlwt/examples/dates.py new file mode 100644 index 0000000..389b93b --- /dev/null +++ b/tablib/packages/xlwt/examples/dates.py @@ -0,0 +1,37 @@ +#!/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') |
