Merge pull request #81 from weirdcanada/frozen-frame-fix

Frozen frame fix

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

test_tablib.py

@@ -5,13 +5,15 @@
 
 import unittest
 import sys
-
+import openpyxl
+import os
 import tablib
 from tablib.compat import markup, unicode
 
 
 
 
+
 class TablibTestCase(unittest.TestCase):
     """Tablib test cases."""
 
@@ -694,6 +696,5 @@ Old       |Man       |100500
         except tablib.InvalidDatasetType:
             self.fail("Subclass of tablib.Dataset should be accepted by Databook.add_sheet")
 
-
 if __name__ == '__main__':
     unittest.main()