title: How to skip one part of a single loop iteration in Python
body: <p>I am creating about 200 variables within a single iteration of a python loop (extracting fields from excel documents and pushing them to a SQL database) and I am trying to figure something out. </p>
  
  <p>Let's say that a single iteration is a single Excel workbook that I am looping through in a directory. I am extracting around 200 fields from each workbook.</p>
  
  <p>If one of these fields I extract (lets say field #56 out of 200) and it isn't in proper format (lets say the date was filled out wrong ie. 9/31/2015 which isnt a real date) and it errors out with the operation I am performing.</p>
  
  <p>I want the loop to skip that variable and proceed to creating variable #57. I don't want the loop to completely go to the next iteration or workbook, I just want it to ignore that error on that variable and continue with the rest of the variables for that single loop iteration.</p>
  
  <p>How would I go about doing something like this?</p>
  
  <p>In this sample code I would like to continue extracting "PolicyState" even if ExpirationDate has an error.</p>
  
  <p>Some sample code:</p>
  
  <pre><code>import datetime as dt
  import os as os
  import xlrd as rd
  
  files = os.listdir(path)
  
  for file in files: #Loop through all files in path directory  
              filename = os.fsdecode(file) 
              if filename.startswith('~'): 
                  continue
  
              elif filename.endswith( ('.xlsx', '.xlsm') ): 
                  try:
                      book = rd.open_workbook(os.path.join(path,file)) 
                  except KeyError:
                      print ("Error opening file for "+ file) 
                      continue
  
                      SoldModelInfo=book.sheet_by_name("SoldModelInfo")
                      AccountName=str(SoldModelInfo.cell(1,5).value)
                      ExpirationDate=dt.datetime.strftime(xldate_to_datetime(SoldModelInfo.cell(1,7).value),'%Y-%m-%d')
                      PolicyState=str(SoldModelInfo.cell(1,6).value)
                      print("Insert data of " + file +" was successful")
              else:
                 continue               
  </code></pre>