diff options
| author | Kenneth Reitz <me@kennethreitz.com> | 2012-11-15 18:50:22 -0800 |
|---|---|---|
| committer | Kenneth Reitz <me@kennethreitz.com> | 2012-11-15 18:50:22 -0800 |
| commit | 5d98239a7e988a1a16261c6cb7073d618b92cfc7 (patch) | |
| tree | caf28d66220ae4910c291c4e528240c177f01d88 /tablib | |
| parent | a3f0d02633a979eb4b11bcea3318fdefd65dcd65 (diff) | |
| parent | e4c39524f7f1bd55428da914b7a99a4cb739ed56 (diff) | |
| download | tablib-5d98239a7e988a1a16261c6cb7073d618b92cfc7.tar.gz | |
Merge pull request #81 from weirdcanada/frozen-frame-fix
Frozen frame fix
Diffstat (limited to 'tablib')
| -rw-r--r-- | tablib/formats/_xlsx.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/tablib/formats/_xlsx.py b/tablib/formats/_xlsx.py index 957fc64..f80f1a7 100644 --- a/tablib/formats/_xlsx.py +++ b/tablib/formats/_xlsx.py @@ -66,6 +66,8 @@ def dset_sheet(dataset, ws): row_number = i + 1 for j, col in enumerate(row): col_idx = get_column_letter(j + 1) + # We want to freeze the column after the last column + frzn_col_idx = get_column_letter(j + 2) # bold headers if (row_number == 1) and dataset.headers: @@ -74,7 +76,7 @@ def dset_sheet(dataset, ws): ws.cell('%s%s'%(col_idx, row_number)).value = unicode(col) style = ws.get_style('%s%s' % (col_idx, row_number)) style.font.bold = True - ws.freeze_panes = '%s%s' % (col_idx, row_number) + ws.freeze_panes = '%s%s' % (frzn_col_idx, row_number) # bold separators |