title: how to set a column to DATE format in xlsxwriter
body: <p>I am working on a project where I am writing out onto an xlsx spreadsheet and need to format the one column for 'Date'.  I get the program to run and all but the column format is still set to 'General'.</p>
  
  <p>Try this in a different way with different code to see if anyone answers.:</p>
  
  <pre><code>for row in cur.execute('''SELECT `Mapline`,`Plant`,`Date`,`Action` from AEReport'''):
      lengthOfHeadings = len(row)
      output = '%s-%s.xlsx' % ("AEReport",now.strftime("%m%d%Y-%H%M"))
      workbook = xlsxwriter.Workbook(output, {'strings_to_numbers':True})
      worksheet = workbook.add_worksheet()
  
      format=workbook.add_format({'font_size':'8','border':True})
      format2=workbook.add_format({'font_size':'8','border':True,'num_format':'mm/dd/yy hh:mm'})
      count = 0
      for name in range(0,lengthOfHeadings):
          if name==row[2]:
              name=int(name)
              worksheet.write(counter, count, row[name],format2)
      else:
          worksheet.write(counter, count, row[name],format)
      count += 1
  counter += 1
  </code></pre>
  
  <p>Slihthinden</p>