title: Write to excel file row by row, instead of column by column
body: <p>I am sorry if the below question is very dumb. I am trying to write an array to file. I tried a few combinations and somehow was able to successfully do this. I don't fully understand how the below work but it works.</p>
  
  <p>I have an array which has a shape (252, 200). When this writes to the file I get 252 columns and 200 rows. I want the 200 data in columns and the 252 data in row. </p>
  
  <pre><code>import xlsxwriter as xls
  workbook  = xls.Workbook('Lookback_Call.xlsx')
  workbook = xls.Workbook('Lookback_Call.xlsx', {'nan_inf_to_errors': True})
  worksheet  = workbook.add_worksheet()
  
  row = 0
  for col, data in enumerate(tst1):
     worksheet.write_column(row, col, data)
  
  workbook.close()
  </code></pre>