summaryrefslogtreecommitdiff
path: root/tablib/packages/xlwt/examples/simple.py
diff options
context:
space:
mode:
Diffstat (limited to 'tablib/packages/xlwt/examples/simple.py')
-rw-r--r--tablib/packages/xlwt/examples/simple.py24
1 files changed, 24 insertions, 0 deletions
diff --git a/tablib/packages/xlwt/examples/simple.py b/tablib/packages/xlwt/examples/simple.py
new file mode 100644
index 0000000..a96f502
--- /dev/null
+++ b/tablib/packages/xlwt/examples/simple.py
@@ -0,0 +1,24 @@
+import xlwt
+from datetime import datetime
+
+font0 = xlwt.Font()
+font0.name = 'Times New Roman'
+font0.colour_index = 2
+font0.bold = True
+
+style0 = xlwt.XFStyle()
+style0.font = font0
+
+style1 = xlwt.XFStyle()
+style1.num_format_str = 'D-MMM-YY'
+
+wb = xlwt.Workbook()
+ws = wb.add_sheet('A Test Sheet')
+
+ws.write(0, 0, 'Test', style0)
+ws.write(1, 0, datetime.now(), style1)
+ws.write(2, 0, 1)
+ws.write(2, 1, 1)
+ws.write(2, 2, xlwt.Formula("A3+B3"))
+
+wb.save('example.xls')