title: stripping data from two XLXS cells to csv
body: <p>im having an issue where im trying to take data from two cells in an excel spread sheet and put them into a csv file. the data is lat and lon coordinates so they have to be side by side to be read by the program.  here is what i have:</p>
  
  <pre><code>#!/usr/bin/env python
  # -*- coding: utf-8 -*-
  
  import xlwt
  import xlrd
  import csv
  import os, openpyxl, glob
  from openpyxl import Workbook
  
  
  with open ('test.csv', 'wb') as csvfile:
    spamwriter = csv.writer(csvfile, delimiter=',')
  
    for file in glob.glob ("/test"):
      wb = openpyxl.load_workbook('test-data.xlsx')
      ws = wb.active
      def lat():
        for row in ws.iter_rows('Q2:Q65536'):
          for cell in row:
            lat = cell.value
            return lat
      def lon():
        for row in ws.iter_rows('R2:R65536'):
          for cell in row:
            lon = cell.value
            return lon  
  
    cord=lat()+","+lon()
    print (lat()+","+lon()) #just to see if its working
    #spamwriter.writerow([cord]) uncomment to write to file
  </code></pre>
  
  <p>however it only gives me the first row of data not the rest of the rows (test-data has around 1500 rows). how would i make it to finish going through the file? </p>