diff options
| author | Kenneth Reitz <me@kennethreitz.com> | 2010-08-28 17:14:39 -0400 |
|---|---|---|
| committer | Kenneth Reitz <me@kennethreitz.com> | 2010-08-28 17:14:39 -0400 |
| commit | b6419d79183dad0965c8574757e333a87761a2fb (patch) | |
| tree | 421e59676715e42e5f6fd7e81f43d312351f81d4 /tablib/packages/xlwt/examples/dates.py | |
| parent | de8ed8dd03f5417e210a7dcd29e694c5b4bfa29e (diff) | |
| download | tablib-b6419d79183dad0965c8574757e333a87761a2fb.tar.gz | |
module name refactorization
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')
|