title: How do I create a workbook using openpyxl?
body: <p>i doing some school work with the openpyxl module. I tried to create a basic workbook object and ran into a problem i am still not able to actually sort out. I have taken a look at the error questions asked before, it seems everyone else is using the same method and it has worked but i dont know why it is just not working for me. I went through the openpyxl documentation and is still porblem unsolved. This is what i did.</p>
  
  <blockquote>
    <blockquote>
      <blockquote>
        <p>from openpyxl import workbook
        wb = workbook()
        Traceback (most recent call last):
        File "", line 1, in 
        TypeError: 'module' object is not callable</p>
      </blockquote>
    </blockquote>
  </blockquote>
  
  <p>and when i use this:</p>
  
  <pre><code>&gt;&gt;&gt; wb = workbook
  </code></pre>
  
  <p>then i get type:</p>
  
  <pre><code>&gt;&gt;&gt; type(wb)
   &lt;class 'module'&gt;
  </code></pre>
  
  <p>but if i try to get the ws objectlike this:</p>
  
  <pre><code>&gt;&gt;&gt; ws = wb.active
   Traceback (most recent call last):
   File "&lt;stdin&gt;", line 1, in &lt;module&gt;
   AttributeError: module 'openpyxl.workbook' has no attribute 'active'
  </code></pre>
  
  <p>so because this have failed i tried another alternative:</p>
  
  <pre><code>&gt;&gt;&gt; ws = wb.get_sheet_by_names
   Traceback (most recent call last):
   File "&lt;stdin&gt;", line 1, in &lt;module&gt;
   AttributeError: module 'openpyxl.workbook' has no attribute'get_sheet_by_names'
  </code></pre>
  
  <p>so i tried to do a version chec with this small code:</p>
  
  <pre><code>import openpyxl
  from openpyxl import workbook
  
  if openpyxl.__version__ == '2.4.1':
      print('Openpyxl is ' + str(openpyxl.__version__) + ' then its up to     date')
  if openpyxl.__version__ != '2.4.1':
      print('Openpyxl is ' + str(openpyxl.__version__))
  </code></pre>
  
  <p>so it seems all the codes i using seems to be the right codes but however will returni cant bury under my depths. I dont actually know whats going on. Would anyone kindly helpout? Thank you in advance.</p>