diff options
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..efe28a0 --- /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')
|
