title: How to read timestamp from excel list in python
body: <p>I am quite new to python and already struggling with an easy task like importing the timestamps of a series of measurement from an excel list. 
  The excel file has one column for date and one for time. I need the data for further calculation like time difference etc. </p>
  
  <p>I tried to different ways how to get the data. So far my codes looks like this:</p>
  
  <ol>
  <li><p>method with pyexcel</p>
  
  <pre><code>import pyexcel as pe
  import datetime
  import time
  from datetime import time
  import timestring
  
  for n in range(len(users)):
      sheet = pe.get_sheet(file_name=users[n],name_columns_by_row=0)
      sheet = sheet.to_array()
      data_meas = np.array(sheet)
  
      for row in range(len(data_meas)):
          print(type(row))
          input_time = data_meas[row,1]
          input_date = data_meas[row,0]
          times = [datetime.datetime.strptime(input_date, input_time, "%d %b %Y %H:%M:%S")] 
  </code></pre>
  
  <p>I get this error for the last line:</p>
  
  <blockquote>
    <p>TypeError: strptime() takes exactly 2 arguments (3 given)</p>
  </blockquote></li>
  <li><p>method with xlrd</p>
  
  <pre><code>import xlrd
  from datetime import time
  inputdata = xlrd.open_workbook('file.xls')
  sheet = inputdata.sheet_by_index(0)
  for row in sheet:
      input_date=sheet.cell_value(row,0)
      input_time=sheet.cell_value(row,1)
      date_values = xlrd.xldate_as_tuple(input_time, inputdata.datemode)
  time_value = time(*date_values[3:])
  </code></pre>
  
  <blockquote>
    <p>TypeError: 'Sheet' object is not iterable</p>
  </blockquote></li>
  </ol>
  
  <p>Does anybody know how to help me?
  I appreciate every hint.</p>