From 954bbdccf32b42bb2871a6dc851eec476fee803a Mon Sep 17 00:00:00 2001 From: Gavin Wahl Date: Mon, 16 Jun 2014 15:31:00 -0600 Subject: Only freeze the headers row, not the headers columns Fixes #53 --- tablib/formats/_xlsx.py | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'tablib') diff --git a/tablib/formats/_xlsx.py b/tablib/formats/_xlsx.py index d697d9c..57058c8 100644 --- a/tablib/formats/_xlsx.py +++ b/tablib/formats/_xlsx.py @@ -115,8 +115,6 @@ 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: @@ -125,7 +123,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' % (frzn_col_idx, row_number) + ws.freeze_panes = 'A2' # bold separators -- cgit v1.2.1