title: Workbook object has no attribute 'add_sheet' when using Workbook object from xlsxwriter
body: <p>Not only am i fairly new to python, but this is my first post on this forum. I am learning how to integrate python and excel. I was able to get the following code:</p>
  
  <pre><code>import numpy as np
  import pandas as pd
  import xlrd, xlwt
  import xlsxwriter
  path = "C:/Users/Python/data/"
  data = np.arange(1, 101).reshape((10,10))
  wb = xlsxwriter.Workbook(path + 'workbook.xlsx')
  ws_1 = wb.add_sheet('first_sheet')
  ws_2 = wb.add_sheet('second_sheet')
  for c in range(data.shape[0]):
      for r in range(data.shape[1]):
          ws_1.write(r, c, data[c, r])
          ws_2.write(r, c, data[c, r])
  wb.close()
  </code></pre>
  
  <p>to work on Jupyter Notebook and through the anaconda python shell, however when i run in Spyder, i get the following error message on the ipython console:</p>
  
  <blockquote>
    <p>runfile('C:/Users/Python/excel_integration1.py',
    wdir='C:/Users/Python') Traceback (most recent call last):</p>
    
    <p>File "", line 1, in 
        runfile('C:/Users/Python/excel_integration1.py', wdir='C:/Users/Python')</p>
    
    <p>File
    "C:\Users\Anaconda2\lib\site-packages\spyder\utils\site\sitecustomize.py",
    line 866, in runfile
        execfile(filename, namespace)</p>
    
    <p>File
    "C:\Users\Anaconda2\lib\site-packages\spyder\utils\site\sitecustomize.py",
    line 87, in execfile
        exec(compile(scripttext, filename, 'exec'), glob, loc)</p>
    
    <p>File "C:/Users/Python/excel_integration1.py", line 7, in 
        ws_1 = wb.add_sheet('first_sheet')</p>
    
    <p>AttributeError: 'Workbook' object has no attribute 'add_sheet'</p>
  </blockquote>
  
  <p>I look forward to all your help.  </p>