Merge pull request #339 from thombashi/replace_deprecated_method

Replace a deprecated method call

3 files changed, 3 insertions, 2 deletions

diff --git a/AUTHORS b/AUTHORS
index 65463bd..e574b85 100644
--- a/AUTHORS
+++ b/AUTHORS
@@ -35,3 +35,4 @@ Patches and Suggestions
 - Tushar Makkar
 - Andrii Soldatenko
 - Bruno Soares
+- Tsuyoshi Hombashi
diff --git a/setup.py b/setup.py
index 0f9da92..2d1b0fa 100755
--- a/setup.py
+++ b/setup.py
@@ -34,7 +34,7 @@ packages = [
 
 install = [
     'odfpy',
-    'openpyxl',
+    'openpyxl>=2.4.0',
     'unicodecsv',
     'xlrd',
     'xlwt',
diff --git a/tablib/formats/_xlsx.py b/tablib/formats/_xlsx.py
index eb921f9..1d29ba8 100644
--- a/tablib/formats/_xlsx.py
+++ b/tablib/formats/_xlsx.py
@@ -52,7 +52,7 @@ def export_book(databook, freeze_panes=True):
 
     wb = Workbook()
     for sheet in wb.worksheets:
-        wb.remove_sheet(sheet)
+        wb.remove(sheet)
     for i, dset in enumerate(databook._datasets):
         ws = wb.create_sheet()
         ws.title = dset.title if dset.title else 'Sheet%s' % (i)