From 5ba6f5d91a151a4376521c93afdf2cefdb213e0c Mon Sep 17 00:00:00 2001 From: Claudio Mike Hofer Date: Mon, 8 Feb 2016 17:30:33 +0100 Subject: frzn_col_idx not defined As in #53 already solved. Freeze panes set to A2 again. --- tablib/formats/_xlsx.py | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/tablib/formats/_xlsx.py b/tablib/formats/_xlsx.py index d9d3d57..411e0fc 100644 --- a/tablib/formats/_xlsx.py +++ b/tablib/formats/_xlsx.py @@ -124,9 +124,10 @@ def dset_sheet(dataset, ws, freeze_panes=True): style = ws.get_style('%s%s' % (col_idx, row_number)) style.font.bold = True if freeze_panes: - # We want to freeze the column after the last column - ws.freeze_panes = '%s%s' % (frzn_col_idx, row_number) - + # As already done in #53, but after Merge lost: + # Export Freeze only after first Line + ws.freeze_panes = 'A2' + # bold separators elif len(row) < dataset.width: ws.cell('%s%s'%(col_idx, row_number)).value = unicode( -- cgit v1.2.1