entrouvert
/
debian-tablib
17
0
Fork 0
Code Issues Pull Requests Releases Activity

Fixed Frozen Frame issue in xlsx export

This commit is contained in:
Aaron Levin 2012-08-01 11:45:12 -04:00
parent 752443f077
commit c88c794314
1 changed files with 3 additions and 1 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

4
tablib/formats/_xlsx.py
View File

@ -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