title: Using xlwt vs openpyxl
body: <p>I need some help with openpyxl in PYTHON. I have been using xlwt quite successfully, but now I have some files (in MySQL Workbench) that contain more than 65,000 rows. I know I can create a CSV file, but XLSX is the preferred output. I am able to create a workbook using openpyxl, but I have not been successful placing the MySQL data into the table. The main portion of the program using xlwt is pretty straightforward (see below). I just cannot seem to figure out how to do the same thing using openpyxl. I've tried a number of different combinations and solutions. I just get stuck after the "for x in result:".</p>
  
  <pre><code>file_dest = "c:\home\test.xls"
  result = dest.execute("select a, b, c, d from filea")
  for x in result:
      rw = rw + 1
      sheet1 = book.add.sheet("Sheet 1")
      row1 = sheet1.row(rw)
      row1.write(1, x[0])
      row1.write(1, x[1])
      row1.write(1, x[2])
      row1.write(1, x[3])
  book.save(file_dest)
  </code></pre>