summaryrefslogtreecommitdiff
path: root/tablib/packages/xlwt/examples/dates.py
diff options
context:
space:
mode:
authorKenneth Reitz <me@kennethreitz.com>2010-10-06 13:42:52 -0400
committerKenneth Reitz <me@kennethreitz.com>2010-10-06 13:42:52 -0400
commit96c93871cf1e8f047b6656912636cc638f2a1808 (patch)
tree877c6e814b2ef0e5670b52121c5f79d709021e77 /tablib/packages/xlwt/examples/dates.py
parenta54949bc08e7323bb7b276d8b8acd7ab0ec5a397 (diff)
downloadtablib-96c93871cf1e8f047b6656912636cc638f2a1808.tar.gz
Vendorized XLWT.
Diffstat (limited to 'tablib/packages/xlwt/examples/dates.py')
-rw-r--r--tablib/packages/xlwt/examples/dates.py37
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')