diff options
| author | Kenneth Reitz <me@kennethreitz.com> | 2010-10-04 11:33:34 -0400 |
|---|---|---|
| committer | Kenneth Reitz <me@kennethreitz.com> | 2010-10-04 11:33:34 -0400 |
| commit | da2b011358e49654eb911cb0c0a76b460ea9afa2 (patch) | |
| tree | 4391f15f1a51a60b815042827ec93008889ec762 /tablib/formats/_xls.py | |
| parent | a8b0bf4b5fc680ab7165d77d69eb976bcd339d09 (diff) | |
| download | tablib-da2b011358e49654eb911cb0c0a76b460ea9afa2.tar.gz | |
Added separator support for XLS output.
Diffstat (limited to 'tablib/formats/_xls.py')
| -rw-r--r-- | tablib/formats/_xls.py | 15 |
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) |
