title: Iterating through excel files and capturing a specific cell value in each file
body: <p>I have a directory of participation forms (as excel files) from clients, and I want to write a script that will grab all of the relevant cells from the participation form and write them to an excel doc where each client is on its own row. When I try and iterate through the directory using the following code:</p>
  
  <pre><code>import os
  import xlrd
  import xlwt
  from xlrd import open_workbook
  from xlwt import easyxf
  import pandas as pd
  from pandas import np
  import csv
  
  for i in os.listdir("filepath"):
      book=xlrd.open_workbook("filepath",i)
      print book
      sheet=book.sheet_by_index(0)
      a1=sheet.cell_value(rowx=8, colx=3)
      print a1
  </code></pre>
  
  <p>I get the error: IOError: [Errno 13] Permission denied: 'filepath'</p>
  
  <p><strong>EDIT Here is the Full Traceback after making edits suggested by  Steven Rumbalski</strong>:</p>
  
  <pre><code>Traceback (most recent call last):
    File "C:\Users\Me\Desktop\participation_form.py", line 11, in &lt;module&gt;
      book=xlrd.open_workbook(("Y:/Directory1/Directory2/Signup/", i))
    File "c:\python27\lib\site-packages\xlrd\__init__.py", line 394, in open_workbook
      f = open(filename, "rb")
  TypeError: coercing to Unicode: need string or buffer, tuple found
  </code></pre>