title: Can't read excel files, using openpyxl
body: <p>I have a list of excel files with similar last row. It contains private information about client (his name, surname, phone). Each excel file corresponds to a client. I need to make one excel file with all data about every client. I decide to do it automatically, so looked to <code>openpyxl</code> library. I wrote the following code, but it doesn't work correctly.</p>
  
  <pre><code>import openpyxl
  import os
  import glob
  from openpyxl import load_workbook
  from openpyxl import Workbook
  import openpyxl.styles
  from openpyxl.cell import get_column_letter
  
  path_kit = 'prize_input/kit'
  
  #creating single document
  prize_info = Workbook()
  prize_sheet = prize_info.active
  
  file_array_reciever = []
  
  for file in glob.glob(os.path.join(path_kit, '*.xlsx')):
      file_array_reciever.append(file)
  
  row_num = 1
  for f in file_array_reciever:
      f1 = load_workbook(filename=f)
      sheet = f1.active
      for col_num in range (3, sheet.max_column):
          prize_sheet.cell(row=row_num, column=col_num).value = \
              sheet.cell(row=sheet.max_row, column=col_num).value
  
      prize_info.save("Ex.xlsx")
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre class="lang-none prettyprint-override"><code>Traceback (most recent call last):
    File "/Users/zkid18/PycharmProjects/untitled/excel_test.py", line 43, in &lt;module&gt;
      f1 = load_workbook(filename=f)
    File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/openpyxl/reader/excel.py", line 183, in load_workbook
      wb.active = read_workbook_settings(archive.read(ARC_WORKBOOK)) or 0
    File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/zipfile.py", line 1229, in read
      with self.open(name, "r", pwd) as fp:
    File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/zipfile.py", line 1252, in open
      zinfo = self.getinfo(name)
    File "/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/zipfile.py", line 1196, in getinfo
      'There is no item named %r in the archive' % name)
  KeyError: "There is no item named 'xl/workbook.xml' in the archive"
  </code></pre>
  
  <p>Looks like it is a problem with reading file.<br>
  I don't understand where it gets an item named <code>'xl/workbook.xml'</code> in the archive.</p>