summaryrefslogtreecommitdiff
path: root/tablib/formats/_xls.py
diff options
context:
space:
mode:
authorKenneth Reitz <me@kennethreitz.com>2010-10-04 11:33:34 -0400
committerKenneth Reitz <me@kennethreitz.com>2010-10-04 11:33:34 -0400
commitda2b011358e49654eb911cb0c0a76b460ea9afa2 (patch)
tree4391f15f1a51a60b815042827ec93008889ec762 /tablib/formats/_xls.py
parenta8b0bf4b5fc680ab7165d77d69eb976bcd339d09 (diff)
downloadtablib-da2b011358e49654eb911cb0c0a76b460ea9afa2.tar.gz
Added separator support for XLS output.
Diffstat (limited to 'tablib/formats/_xls.py')
-rw-r--r--tablib/formats/_xls.py15
1 files changed, 7 insertions, 8 deletions
diff --git a/tablib/formats/_xls.py b/tablib/formats/_xls.py
index ccb236a..04cd9a2 100644
--- a/tablib/formats/_xls.py
+++ b/tablib/formats/_xls.py
@@ -19,12 +19,11 @@ def export_set(dataset):
ws = wb.add_sheet(dataset.title if dataset.title else 'Tabbed Dataset')
_package = dataset._package(dicts=False)
- print dataset._seperators
-
- for sep in dataset._seperators:
- _package.insert(sep[0], (sep[1],))
-
+ for i, sep in enumerate(dataset._separators):
+ _offset = i
+ _package.insert((sep[0] + _offset), (sep[1],))
+
for i, row in enumerate(_package):
for j, col in enumerate(row):
@@ -32,11 +31,11 @@ def export_set(dataset):
if (i == 0) and dataset.headers:
ws.write(i, j, col, bold)
- # bold seperators
- elif i in [sep[0] for sep in dataset._seperators]:
+ # bold separators
+ elif len(row) < dataset.width:
ws.write(i, j, col, bold)
- # write the rest
+ # wrap the rest
else:
ws.write(i, j, col, wrap)